Download .pbix file having semantic model modified by XMLA endpoint

[kharedev2418]

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.

[kharedev2418]

Thanks @nilendraFabric  for your insights. I was able to use this approach and overcome my scenario.

[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.

[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.

[nilendraFabric · Accepted solution]

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 Desktop

try 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