Plenty to read!
All tagged Automation
In this article, I explain several use-cases for semantic-link-labs with reports, which involves programmatic modifications to report metadata to streamline certain report management tasks. This article explains how to do this with standard reports; future articles will elaborate about using the methods available for PBIR.
This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API.
In this short article, I show you how to upgrade the compatibility level of models managed in Tabular Editor to be able to use new/preview features like Dynamic Format Strings.
In this article, I share a C# script to run a randomized, 10-question, eduacational quiz about Tabular Editor.
Learn Tabular Editor… inside of Tabular Editor!
This article is a fun one-off sharing a Tabular Editor C# script to play a Snake game.
In this article we look at four different ways to query data from within Tabular Editor. I also share a C# script to query or test selected columns and/or measures.
In this post we look at how to use Smart Buttons (flic) with Power Automate and Power BI to create and control types of event-driven reporting solutions.
We look at how Tabular Editor shortcuts can revolutionize your productivity, linking them to macros, common actions and more.
This short article explains how to quickly count measures (or any model object) in Tabular Editor. A C# script is provided to count all model objects as a quick pop-up.
Have you ever wondered how to convert Power BI metadata (i.e. from Tabular Editor) to a .pbix? Recently, I needed to do this. Thankfully, pbi-tools (and Mathias Thierbach) came to the rescue! This is not supported by Microsoft, but it’s interesting to know that this approach does exist.
In this post, we look at a simple way to extract the tenant settings from Power BI using Power Automate Desktop and a UI Automation / RPA flow. Inside, we have a summary of the settings and recommendations for each, as of April 2022.
In this article, we examine a method to automatically monitor & test data quality in Power BI by setting up a composite model to detect data changes.
