Forum Discussion
Abort table refresh conditionally
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 e...
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