Replace data sources in Power Query with published Power BI dataset
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…
How can I export the underlying data in Power BI?
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…
COVID-19 latest vaccination statistics now available for whole Switzerland on impfstand.ch
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…
COVID-19 current vaccination numbers for the canton of Basel-Stadt, Switzerland
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…
Trigger automated workflows directly and with filter context in Power BI Report with Power Automate Visual
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…