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...
Tag - Data Model
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.
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...
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.
I wanted to find an easy-to-use documentation script for my data models. In Tabular Editor`s documentation there is a useful script for generating documentation. I thought I will use what Daniel Otykier created as a starting...
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...