Power Platform fun times | bi_ome
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