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...
Category - Improve the Experience
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...
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...
What is referential integrity and why you need to make sure you have it. Learn how you can find and solve issues with it.
Turn Best Practice Analyzer recommendations into Custom Actions in Tabular Editor. Improve your data models with a few clicks.
When I began working with Power BI, all the datasets I created were intended to support the reports I was building. However, as more of my colleagues started embracing Power BI, they also wanted to create their own reports...