Forum Discussion
Power BI Enhanced Refresh API bug refreshing single table
Hi Anonymous ,
This behaviour is not explicitly detailed in the Refresh API documentation. However, it is a known characteristic how Power BI handles dependencies between model objects (example : calculated tables, relationships, and measures). In the below power bi document of calculated tables, this is mentioned. PFBS for reference.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hi Anonymous ,
Thank you for reaching out to Microsoft Fabric Community.
Even when using "DataOnly" with the Enhanced Refresh API, Power BI may still refresh additional tables beyond the one specified. This often happens when the selected table (e.g., Calendar) is referenced by other objects in the model such as calculated tables, relationships, or even measures. In these cases, the API tends to be cautious and triggers refreshes or recalculations on those dependent objects as well, even if they aren't explicitly listed.
As you said, using XMLA endpoint will be better fit for more granular control, as it typically respects object-level refreshes more strictly
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hi - thanks for your response, can you point us towards some documentation that supports what you have said, or at the least can you state that this is official information? How do you know this? The reason I ask is that none of this is stated anywhere in the API documentation, so we would like to know whether this is the 'official' behaviour of the Refresh API
Thanks!
Josh
Hi Anonymous ,
This behaviour is not explicitly detailed in the Refresh API documentation. However, it is a known characteristic how Power BI handles dependencies between model objects (example : calculated tables, relationships, and measures). In the below power bi document of calculated tables, this is mentioned. PFBS for reference.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!