Model metadata in Power BI is getting more and more accessable and there are a fair amount of tool that we can use to work with it. Report metadata on the otherhand is not easy to work with. In my previous blog post, I showed...
I had a task to help a managed services team in monitoring multiple production datasets and reports in Power BI. These resources, accessed by thousands of users, demanded optimal performance. For this we had to streamline...
I spend a lot of time going through the Power BI documentation to find answers about Power BI features. As always, I look for opportunities to make my life easier when I need to look through of data. What better tool for this...
In the first two parts (part 1 and part 2) of the blog we explored the Show details functionality of a Pivot table in Excel. Now we look at another hidden feature that will help you limit distractions. Whenever you connect to...
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In this blog we are going to talk about increasing the records retrieved by...
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In this blog we are going to talk about Detail Rows Expressions.
Data Types has been part of Excel for some time now, but a lot of people is not familiar with it. You can find them under the Data tab. You might have wondered what they are for? They are built-in datasets about common...
It has been a while I published about Documenting a data model in Power BI. I thought I would update the solution with some added features to make the documentation more complete. Updated the meta data that can be extracted...
I have been reading a lot of good feedback of the Power BI May 2022 update especially and the introduction of field parameters. Do not want to go into details what it is, because the official blog post and video gives a good...
Slicer and filter were around in Power BI for a long time now, and plenty of blog posts were created comparing them to each other. Because these features constantly get updated and there are considerations outside of just a...