What the fact.bi - All about Power BI, DAX, M, Power Query

This post is also available in: Deutsch

How to create a service principal for power bi

I will show you, how you can easily create an Azure service principal for Power BI! […]

Persisting temporary accessible data via Power BI Datamarts with the example of Power BI Activity Logs

You can persist temporary accessible data like the Power BI Activity Logs only with Power BI Tools! With Power BI Datamarts and a data flow this is easily achievable! […]

Loading Web Data into Power BI Service without Using a Gateway

This post is also available in: Deutsch Many times, I’m creating a report in Power BI Desktop with data from a website. As an example, let’s imagine we create a report and load the population by country from this Wikipedia page. I’m loading data in Power Query from the web and at one point I am publishing my report to the Power BI Service. Option to schedule refresh is disabled After publishing the report, I want to schedule the report. But when I want to schedule the refresh, the settings look like that: Why is the scheduled refresh section grayed out? I don’t see any hint why this would be. But there is one spot that gives you a hint. When you try to refresh the data manually, you will see an error: And when you click on it, you will see the details: Error message mentions gateway The error message is a little confusing, why does Power BI complain about a gateway? We are loading from the cloud (Wikipedia) directly to the cloud (Power BI Service). It wouldn’t make sense to use a gateway.By default, the function Web.BrowserContents will be used to load a website in Power Query. […]

What are the strange symbols in a Power BI relationship? All you have to know about weak or limited relationships

In a Power BI data model you sometimes find funny symbols in the relationship itself. This means that it’s a weak or limited relationship. In this article I will explain everything about weak relationships! […]

Change your slicer easily from OR to AND logic in Power BI

This post is also available in: Deutsch In Power BI, slicers generally have OR logic implemented. This I normally also exactly what the user wants to happen. If I select the years 2021 and 2022 in a slicer, then I would like to see the values in the result which are either related to the year 2021 or to the year 2022. OR logic not always the correct one Sometimes, however, there are situations in which this is not the desired behavior. Let’s say we want to identify customers who bought “Product A” while also buying “Product C”. In such a case, I would like to select both products in the slicer. As a result, only those customers who have purchased both products should be displayed in a table.For such a case I need an AND logic for my slicer. In principle, the logic of the slicer cannot be changed. But I can create an AND logic with a measure and then either return only the desired result or filter a visual with the measure. Example Scenario – Which Lord of the Rings character got which weapons As today’s example, let’s take our characters from Lord of the Rings. […]