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…
Automatically filter report on actual date with calculated column and with measure
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…
Automation in Power BI – Format all measures, replace text, set default summarization and more
One topic that I think doesn’t get enough attention is the ability to automate work in Power BI with the Tabular Editor. Especially the official documentation gives some nice insights into what the scripting engine can achieve.I would like to present a few examples in this article. Example 1: Automatic formatting of all measures If…
What is a Measure table and how can I create it properly
Although the feature has been in Power BI for a while, Measure Tables are not used enough in my opinion. Also during my trainings or in conversations with customers, I often notice that the feature has not really reached the minds of the report developers yet. What is a Measure Table and what does it…
Understanding Power BI Embedded with Source Code and Contoso Example Portal
Power BI Embedded is a great way to integrate entire reports or specific elements from a Power BI reports into a company portal. Unfortunately, this is not always easy to explain and you need some imagination to grasp how this might look in practice. Power BI Embedded as a demo portal However, this has recently…