In this blog we will go through an issue I had with a table and I needed to exclude it from the report refresh so that the report could refresh normally for the other tables until the issue was fixed on the backend.

Since I didn’t have the SQL credentials, I had to exclude it from the report refresh without using Power Query, as that would require credentials.

Luckily, I was able to do this using the TMDL view introduced in the January 2025 update. Here’s how:

Welcome to the first week of the qualifying rounds for the Power BI DataViz World Championships! Read on to learn what the featured data is for the week, the requirements for your build, and how to submit.

You ask, we answer! This is a list of some of the frequently asked questions about the upcoming Power BI DataViz World Championships.

How can we use variables effectively while creating custom columns in Power Query?