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

This post is also available in: Deutsch

How can I export the underlying data in Power BI?

This post is also available in: Deutsch In Power BI, I repeatedly encounter the situation that it does not work to export the underlying data. The option is simply not available. In general, this can have several reasons. In the following article we will take a look at the possible reasons for this. 1. Disabling in Power BI report The author of a report can limit the export for the specific report. For this purpose, it is possible to select in the options in Power BI Desktop whether users are allowed to export summarized data, the underlying data or no data at all: 2. At least build permission in Power BI Services Most of the time the error is due to the missing permissions. In order to export the data, the user needs at least the build permission for the corresponding data set. As soon as the user has more permissions for the data set, for example administrator permissions, it does not matter anymore. But as a normal user with read permissions, the build permission must be set additionally. How exactly this is done is explained in the documentation:https://docs.microsoft.com/power-bi/connect-data/service-datasets-build-permissions 3. Sensitivity label for data set If the first two […]

COVID-19 latest vaccination statistics now available for whole Switzerland on impfstand.ch

This post is also available in: Deutsch A few weeks ago, I visualised the current status of vaccinations in the canton of Basel-Stadt with Power BI in a weekend project. I have received a lot of positive feedback in response to this. Many thanks at this point for that. In addition, there were numerous requests to extend the report to cover the whole of Switzerland. It took a few days, but the report now contains data for the entire country. The Power BI Report can still be accessed at: https://impfstand.ch The selection of the canton can easily be done using the navigation: New features that are now included are: Consideration of the individual cantons or of Switzerland as a whole. Current vaccination statistics can be filtered to the population aged 20 and above. This was implemented because the vaccinations are only permitted from the age of 16 and 18 years. Unfortunately, population figures are only available from 20 years of age and up. First and second vaccination by day of the week. Comparison of first and second vaccination between all cantons. In the next few weeks there will be some changes, including an English version. Therefore, you are welcome […]

COVID-19 current vaccination numbers for the canton of Basel-Stadt, Switzerland

This post is also available in: Deutsch This past weekend, I had an aha moment. My girlfriend asked me what the current status of COVID-19 vaccination was here in Switzerland in our area, which means in the canton of Basel-Stadt. After a short internet research, we found either newspaper articles that were already a few weeks old or statistics that presented the current figures only insufficiently or in a complex way. The canton of Basel-Stadt provides all data as CSV and JSON on its Open Data Basel-Stadt website and allows the use under the Creative Commons license. Current vaccination status as Power BI Report for Basel-Stadt As a Power BI enthusiast, I immediately thought of presenting the whole thing in an easy-to-understand Power BI report. No sooner said than done, I prepared the data in Power BI, hopefully presented it in an easy to understand way, and created a website for it. May I introduce: https://impfstand.ch […]

Trigger automated workflows directly and with filter context in Power BI Report with Power Automate Visual

This post is also available in: Deutsch Last Friday, Microsoft released the latest Power BI update a little earlier than usual. The highlight from my point of view is the Power Automate Visual ( previously Microsoft Flow), which works with the now released April 2021 version of Power BI. What is Power Automate? With Microsoft Power Automate it is possible to combine tasks and workflows with different applications in order to automate them. Over 300 services are now supported, for example Dropbox, Outlook, Power BI, Sharepoint, Twitter, SalesForce, etc. Application areas can be simple notifications, but also very complex and highly automated workflows.A few examples could be: There is also a Windows application that can be used to automate operations in other desktop programs. Overall, a very enjoyable thing that actually makes working life a lot easier and significantly increases productivity. So how does this work in Power BI? The process in relatively simple. The first step is to add the Power Automate Visual from the Marketplace: After adding the new visual, it also lets us know what the next steps are: Create tasks for individual orders in Microsoft To Do My demo flow is to create a task […]

Automatically filter report on actual date with calculated column and with measure

This post is also available in: Deutsch Sooner or later, every Power BI developer will face the question of how to automatically filter a specific visual or the entire report to today’s date.This can be done in two ways: The approach with a calculated column is much more stable, since measures generally cannot or should not be used as filters. However, if the date exists in the filter context, then this is also possible with a measure, which is why I will present both alternatives. Filter to today’s date with calculated column As just said, filtering by calculated column is the more stable of the two approaches. Here, a new calculated column is created in the date dimension, where it is simply checked whether the date in the particular row matches today’s date: In this way, the content of the new calculated column is always “0”, except for the current date. On this day the line shows a “1”: The new column can now be used to filter single visuals or the whole report on today’s date. As soon as the day changes, the value in the calculated column also changes and the report adjusts to the new date […]