Forum Discussion
Download .pbix file having semantic model modified by XMLA endpoint
I have used Microsoft Tabular Object Model and connected to a sematic model in my workspace. Performed few operations like adding new tables to database (semantic model representation in Microsoft.AnalysisService.Tabular) and saved changes.
After performing the change, I'm not able to download .pbix file. Do we have any way to download it?
Copying/cloning report only copies the report visuals but not the semantic model.
Hello kharedev2418
Semantic models that have been modified using the XMLA endpoint cannot be directly downloaded as a .pbix file from the Power BI service. This limitation exists because changes made through the XMLA endpoint can introduce complexities that are not compatible with the standard .pbix file format.
The XMLA endpoint allows for advanced modifications that may not be fully supported in the .pbix format used by Power BI Desktop
Some modifications made via XMLA might rely on features specific to the Power BI service that don't have direct equivalents in Power BI Desktoptry this workaround using Tabular Editor:
- Create an empty Power BI project (.pbip) file
- Open the XMLA model with Tabular Editor
- Save the model over the empty .pbip file
- Open the .pbip in Power BI Desktop and save as .pbix
https://docs.tabulareditor.com/te3/powerbi-xmla-pbix-workaround.html
If this is helpful , please accept the answer and give kudos
5 Replies
- nilendraFabric
Super User
Hello kharedev2418
Semantic models that have been modified using the XMLA endpoint cannot be directly downloaded as a .pbix file from the Power BI service. This limitation exists because changes made through the XMLA endpoint can introduce complexities that are not compatible with the standard .pbix file format.
The XMLA endpoint allows for advanced modifications that may not be fully supported in the .pbix format used by Power BI Desktop
Some modifications made via XMLA might rely on features specific to the Power BI service that don't have direct equivalents in Power BI Desktoptry this workaround using Tabular Editor:
- Create an empty Power BI project (.pbip) file
- Open the XMLA model with Tabular Editor
- Save the model over the empty .pbip file
- Open the .pbip in Power BI Desktop and save as .pbix
https://docs.tabulareditor.com/te3/powerbi-xmla-pbix-workaround.html
If this is helpful , please accept the answer and give kudos
Thanks nilendraFabric for your insights. I was able to use this approach and overcome my scenario.
v-hashadapuCommunity Support
Hi kharedev2418 , Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.- v-hashadapu
Hi @kharedev2418 , Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Thank you nilendraFabric for your response. - v-hashadapu
Hi @kharedev2418 , Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
