Forum Discussion

ahmedshalabyy12's avatar
ahmedshalabyy12
Helper V
1 year ago
Solved

Corrupted pbix File

Hello, there's a semantic model uploaded it to the service , and refreshed it through XMLA . today i was opening it from my local pc but it's corrupted . and i cannot download it from the service ...
Need Help
  • ahmedshalabyy12's avatar
    ahmedshalabyy12
    1 year ago

     C:\Users\*yourusername*\AppData\Local\Microsoft\Power BI Desktop\TempSaves
    this will work 

grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

Hi ahmedshalabyy12 ,

Try below method:

Rebuild Local File by Scripting from Service

 

  • Open Tabular Editor (2.x or 3.x).

  • Connect to your dataset via XMLA:

    powerbi://api.powerbi.com/v1.0/myorg/YourWorkspaceName
     

  • Select your semantic model, it opens the full data model.

  • File → Save to Folder (creates a folder-based Tabular Model).

  • OR: File → Save As .bim file

    Then:

    • Open Power BI Desktop

    • Create a new file

    • Use External Tools > Tabular Editor to inject the saved model back into a fresh .pbix.

      🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
      💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
      🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
      🔗 Curious to explore more? [Discover here].
      Let’s keep building smarter solutions together!

ahmedshalabyy12's avatar
ahmedshalabyy12
Helper V
1 year ago

Hello,

thank you for your comment , now i have conncted tabular editor with service and saved my semantic mode as a new folder .

then i opened a new file power bi desktop , opened tabular editor then file >> open from folder 
it retreive the semantic model inside tabular editor . when i click save i don't find the tables in power bi desktop 

 

am i doing something wrong ?

thank you 

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    1 year ago

    Hi ahmedshalabyy12,

    You have done most of it right so far. Just to explain  when you bring the model back into Power BI using Tabular Editor, it only brings the structure like tables and measures, but not the actual data or the report visuals. That’s why you’re not seeing anything show up in Power BI Desktop.

    First option  open Power BI Desktop and use Get Data > Power BI Datasets to connect to your published model directly from the workspace. That gives you access to the data, and you can start rebuilding your visuals from there.
    Second option  if you still want to use the saved model from Tabular Editor, you will need to manually bring the data back in using Power Query or refresh it using XMLA.

    Also just a heads-up since incremental refresh is turned on, Power BI blocks the download of the original .pbix, which is why that option is not working.


    Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
    Regards,
    Harshitha.




    • ahmedshalabyy12's avatar
      ahmedshalabyy12
      Helper V
      1 year ago

      Thank you for your comment but yes i need to retreive the structure of the data using tabular editor then refresh it , all i need is the semantic model and unfortunately i didn't apply git solution yet 😞