Abort table refresh conditionally

[Maria_Maria]

There is a great idea to check if the table is empty and abort refresh if it is to avoid empty visuals shown in the report.

EmptyCheck = if Table.IsEmpty(dbo_Employees) = true then error "Table is empty. Update aborted" else dbo_Employees

But if there is more than 1 table used in the report then PBI aborts all the tables' refreshes with 'blocked by failuers in other queries' reason.

Is there a way to re-wite this query so that PBI aborted refresh only for the tables that are empty.

I understand that I need to change '... then error' part to something different, but can't seen to figure out what.

Appreciate your help.

[miguel]

Hey!

This is currently possible via the XMLA endpoints. The XMLA endpoints offer you the ability to define what tables need to be processed / evaluated and which ones you don't want to re-evaluate. Furthermore, you can also go to a partition level to execute the queries that way.

For Power BI Desktop the refresh always occur for all tables or, in other words, for the full data model. You have more control once it's published in the service and you interact with the data model through the XMLA endpoints.

Below is a link to an article that talks more about these capabilities with the XMLA endpoint:

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs