Date tables are one of my favorite things in Power BI, right up there with field parameters. Particularly the ability to make all of my date filtering relative is one of the things I really love about them – it can really reduce the maintenance for reports to have measures and filters “stick” to current… Continue reading: Date Tables in Power BI
YES you can use incremental refresh on SharePoint files in Power BI! The trick is, the date column you use needs to be something OUTSIDE the file, such as the “created date” column in the SharePoint library. What that means, is, this is only really useful for SharePoint folder sources, where Power BI is grabbing… Continue reading: Can you use incremental refresh on SharePoint file sources in Power BI?
The matrix visual in Power BI is a bit fiddly to work with, particularly when you’re working with text-based data. It likes to auto-summarize any text fields you add, and typically you want a little more control over the header groupings than it wants to give. Here’s an example of what the task data looks… Continue reading: How to Make Your Matrix Behave
In the video tutorials for how to send a basic HTML table from Power BI with Power Automate and similar for styled tables, a question came up about what to do if the query to the Power BI dataset returned blank for a given user – if it has no rows to show, it will… Continue reading: Sending HTML Table Emails from Power BI with Power Automate – Handling Blanks
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
There’s not a connector for premium like there is for basic Planner! 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 use the Dataverse connector to update premium Planner tasks: I tested this out using a basic “update… 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