Power Platform fun times | bi_ome
If you use Microsoft Planner or Project for the Web, you’re probably familiar with the colored labels you can add to tasks. These can be renamed to whatever you like; they’re used to “flag” tasks. When we pull this task data into Power BI, we lose a lot of the label details. If we’re using … Read more
This started out as a offhand question to ChatGPT just to see what it came up with, but it ended up being WAY more insightful than I expected, so I did a few more to share them. Me, anthropomorphizing? YES ALWAYS. By the way, NEVER ask me “if you were an animal, what would you … Read more
Early on when the SharePoint Online List 2.0 connector was released, I did some internet searching to see why you’d use the new connector vs the old connector. It turned up a lot of posts like this, where it was stated that the limit on the 2.0 connector was a maximum of 5000 returned rows. … Read more
I run into this problem more times than not when setting up tables in Dataverse to use with Power BI. Why does this happen? I have no idea. After creating the table, I go to search for it in the Power BI Dataverse connector menu and the table doesn’t show up. Waiting it out doesn’t … Read more
You may have noticed that if you’re trying to make a Gantt chart in Power BI, there aren’t a ton of really great options, particularly in the “free” category. I picked up David Bacci’s Deneb template because it does milestones, dependencies, and phases, which the Microsoft Gantt is pretty lacking in feature-wise. David Bacci has … Read more
Every time you make a Power BI report, there’s a million things you need to remember to do both as you go along and when you launch it. PARTICULARLY if you’re trying to follow best practices, it can be a lot to remember. What I like to do is make a checklist for this, and … Read more
If you’re looking for a simple no-code way to get Microsoft Planner data, Power Automate is the way to go. We can create a scheduled flow that stores the data in a SharePoint Online path, then connect to that file with Power Query in Power BI or Excel! Create a Scheduled Power Automate flow In … Read more
SharePoint Online sources in Power BI do not require a gateway to schedule a refresh, making them a very convenient storage solution for file sources – in addition to things like SharePoint lists. You can use a gateway for SharePoint Online sources, but you would need to create a connection in the gateway for every … Read more