This post is also available in: DeutschDeutsch

Replace data sources in Power Query with published Power BI dataset

This post is also available in: Deutsch Occasionally, as a Power BI developer, you are faced with the task of replacing the data source in existing reports with a published Power BI dataset. Especially if there are already several reports that were created with a copy of a PBIX file and are now to be consolidated to the same dataset. The question here is how best to proceed in order to achieve the goal as efficiently as possible. Delete the old data I had tried many approaches in the past, but the simplest one is by far the most efficient. I would like to demonstrate this using the example of my vaccination statistics, where I access the dataset of the German report for the English version. Still I would like to take the visualization as a basis from the original report. In the first step we need to delete the existing data. This sounds brutal at first, but trust me, the individual visuals will work again later when all tables, columns and measures are named identically. 1) So in the first step, we delete all the tables created by DAX, including the Measure table, directly in Power BI: 2) […]
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 […]
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 […]
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 […]
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: When a new record is added to a SQL Server table, push it to a Power BI Live Dataset If I got linked on Twitter, send me a message in Microsoft Teams When a new lead is created in Dynamics CRM, start a new workflow, notify the responsible employee by email and save copies of the job as a PDF in Dropbox 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 […]