XMLA - cannot download .pbix after updating dataset with External Tools (XMLA Read/Write)

[Migasuke]

Hi community,

I am working on a dataset, which is managed via XMLA endpoints. After changes the file can't be downloaded anymore from PBI Service.

I found the same questions from 2020 and basicaly there was no solution back then
https://community.powerbi.com/t5/Service/Cannot-download-pbix-after-updating-dataset-with-External-T...

Is there anyone who has some news or ideas, which can help nowedays?

Thank you!

[AlexisOlson · Accepted solution]

This is a documented limitation:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix

• Reports created in the Power BI service that are based on a single dataset that's configured for large models or incremental refresh, or that has been modified by using the XMLA endpoint can only be downloaded in live connected report mode.
• Datasets modified by using the XMLA endpoint can't be downloaded to a .pbix file.

There may be workarounds but I haven't tried these myself.

[Migasuke]

Thank you,

I hope they will get rid of this limitation one day.