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 →

When you configure a data alter inside a Power BI dashboard, you cannot configure another email address or modify the text inside the email. Another problem is when you want to inform another user. So, here you can use Power … Continue reading →

In the past, some customers asked me, how can I change the path for a local, imported file, to a path which can be refreshed by Power BI Online. You have two options, you can install a Power BI Data … Continue reading →

Power BI composite models are not really new, but in my point of view, a really underestimated feature and in my experience, not really often used. Let’s assume, you have two different departments, and every department creates its own models … Continue reading →