I used to live in Evernote. Then it started wanting money to sync multiple devices. Now it considers the web UI a “device” in that multiple devices category, so I can’t use it on any local device at all and still access in the web, so that’s cool. I’m trying to unpack gigabytes of ENEX… Continue reading: How to convert Evernote .enex backups to markdown
Looks like no! This topic comes up a lot, and I had a hunch that it wasn’t as simple as you’d expect, but it turns out you really can’t: I tested this out using a basic “update a row” with the Dataverse connector to modify a single task and this was the error it gave.… Continue reading: Can you update a task in Premium Planner for the Web with Power Automate?
A BIM file in Power BI holds information about the semantic model – tables, columns, measures, queries, etc. It doesn’t hold any data. You can generate a BIM file using Tabular Editor: Open a semantic model with Tabular Editor and choose “Save As” from the File menu to save a BIM file. There’s a popular… Continue reading: BIM Files in Power BI: You can use them as a data source!
If you’ve been following my series on how to get Planner data (basic Planner, not premium) with Power Automate, you may have noticed that there is not a “completed by” user name or ID field available as a dynamic content card. We can still get the completed-by data using direct references to the JSON output… Continue reading: How to get “completed by” user data for Planner
I went to sign up for a new Microsoft 365 tenant today and ran into an issue when trying to purchase as part of the registration process – every payment method I tried came back as invalid. I quite honestly gave up and decided to come back to it later, but when I came back… Continue reading: Fix for “Object reference not set to an instance of an object” error when updating organization name in Microsoft 365
Power BI has a feature that allows you to add source tables to a report that is referencing a published semantic model. This is a really big deal in data modeling land, because previously if you wanted to add a minor table for some additional use case that you only needed for one report, you… Continue reading: Adding sources to a “thin” report
Power Automate actions produce JSON outputs. Depending on the connector you’re using, you can oftentimes reference these using the built-in dynamic content cards that appear in the UI. But what happens when you want to reference something that’s NOT in the dynamic content card list? Option 1: Use PowerFX to reference values You’d use this… Continue reading: How to parse or extract specific things from Power Automate JSON outputs
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?