See this post
https://community.fabric.microsoft.com/t5/Service/XMLA-connection-is-randomly-failing/m-p/4777982#M2...
But the nutshell is that XMLA endpoint in Excel is a totally unreliable method for final user since
- GETPIVOTDATA is impacted by the internal Excel caching of data and there is NO WAY for the user to disable this cache: this means that you don't know if your data is up to date or not. This is a product breaking limitation because you cannot trust the product at all and as the feature is advertised as self-service BI, you cannot really release to final, non-tech, users
- the connection sometimes simply fails. You try to refresh a report, hit refresh, takes a while and data is not refreshed
- when converting the table from GETPIVOTDATA to CUBEVALUE some metrics are simply removed and not converted, even if they're simple queries
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...
on:
Power BI Subscriptions enhancements sorely needed
on:
Ragged Hierarchy Display options in Matrix Visual
miguel
on:
Personalized Source List in Get Data