Forum Discussion

qasimkhan's avatar
qasimkhan
New Member
1 year ago
Solved

Data Models gets deleted when I open the file in Desktop

Hi Everyone!

I'm facing an issue like never before. I have a report that has many tables connected to SQL server. It is running fine on Power BI Server, the data gets updated every two hours and it's working perfectly fine. 

However, when I try to open the file in Power BI Desktop. It gives me a popup that says something like: "You have pending changes. Apply or Discard" 

When I hit Apply, all my visuals go away and a "Fix this" button appears on all of the visuals. 

Please note that this happens to both Report file and the Semantic Model File. I've tried everything, but no luck. 

Any help would be greatly appreciated 

Need Help
  • GilbertQ's avatar
    GilbertQ
    1 year ago

    Hi qasimkhan 

     

    I have noticed this is has happened to me in the past. What I can recommend doing is just click on discard and everything should remain as is. I think that there is a bug with the software.

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    1 year ago

    Hi qasimkhan 

     

    I have noticed this is has happened to me in the past. What I can recommend doing is just click on discard and everything should remain as is. I think that there is a bug with the software.

    • qasimkhan's avatar
      qasimkhan
      New Member
      1 year ago

      I cannot thank you enough GilbertQ 

      I spent 3 hours trying to figure it out how to fix it and your solution worked like a charm! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi qasimkhan,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    It looks like the issue you are facing in Power BI Desktop where you see a "Pending Changes" prompt and broken visuals after applying changes. This may happen because of various reasons. Try to look at the mentioned points and do some troubleshooting steps.

    * Check if there is any Data source connection mismatch. Try to update credentials in Power BI Desktop.

    * Also check if there is any schema changes done in SQL Server. Modify your Power Query steps to match new

       schema (if changes happened).

    * You can also clear cache and restart Power BI.

     

    I would also take a moment to thank GilbertQ, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.
    Community Support Team

     

    If this post helps then please mark it as a solution, so that other members find it more quickly.

    Thank you.