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… Continue reading: Microsoft Planner / Project for the Web Color Label Values
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… Continue reading: If Power Platform apps were animals, what would they be?
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.… Continue reading: SharePoint List 2.0 Power BI Connector: Is the Limit 5000 Rows?
It depends on exactly what functionality you need, who your form submitters are, and what licensing you have available to use. Are your form submitters internal organization users or anonymous/external? If your submitters are external and not being explicitly invited with their Microsoft 365 accounts, the answer is going to be Microsoft Forms or Power… Continue reading: Which tool should I use to make a form in Microsoft 365?
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… Continue reading: New Dataverse table isn’t showing up in Power BI? Here’s the fix.
If you went looking to create a custom connector and had trouble finding the button, you’re not alone. You’d probably expect the option to be in the “connectors” menu option in the Power Apps maker portal, but no! The connectors page will only let you create a connection from an existing connector. To create a… Continue reading: Can’t find the “create a custom connector from blank” button?
When you’re working with Dataverse sources in Power Automate, there’s a few hoops you need to jump through – particularly when you’re working with lookup and choice-type fields. When you insert a dynamic content card for a Dataverse choice field into an action, such as if you’re sending an email or approval and want to… Continue reading: Dataverse Choice Fields: How to get the text value in Power Automate
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… Continue reading: How to use David Bacci’s Gantt Deneb Template
Setting form fields in Power Pages via the URL – meaning that when someone clicks a link, certain fields are pre-set according to content in the link – can be done with JavaScript in Power Pages! The documentation on this is a bit light, and Chat GPT was not very useful in writing code to… Continue reading: How to set Power Pages form fields via URL parameters (including lookup fields)
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… Continue reading: Create a Power BI Best Practice Checklist