Inside excel you have the possibility to hide columns inside tables and pivot tables. Inside Power BI you don‘t have the possibility. If you want to achieve this behavior, there are some options. In this example I have created a … Continue reading →

If you assign tags to PPIs or tasks inside DevOps and you want to analyze them with Power BI you can use analytic views to extract this information and put them together with the tasks to create a report. Then … Continue reading →

In the last few weeks, some Colleagues asked me, why they cannot use the new suggested measure feature. They said to me, that they followed every step inside the Power BI blog posthttps://learn.microsoft.com/en-us/power-bi/transform-model/quick-measure-suggestions The reason is simple, the Power BI … Continue reading →

A customer told me, that he have a system with polls which collects numbers and strings as an answer. The result looks like these: Now, he wants to summarize the numbers and also to show the written answers. Next, I … Continue reading →

In my scenario, I get 1000 JSON files per day, which must be analyzed with Power BI. So, I will get approx. 380 million rows per year. The system has an initial load of circa. 500 Mio. rows. So, I … Continue reading →

A colleague said to me, that we can create a live dashboard in Power BI which displays actual data from database. I said NO! This post will show you, what you can do to achieve this goal. I’ve created a … Continue reading →