Forum Discussion

lh2275's avatar
lh2275
New Member
2 months ago
Solved

SQLite error code=1 ("SQL error occurred or database is missing") when opening PBIX files downloaded

Hi everyone, I'm running into an error when opening PBIX files that colleagues shared via a Microsoft Teams channel (SharePoint document library). Error message: "An SQL error occurred or the data...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    2 months ago

    lh2275 

     

    1. Power BI keeps internal metadata in a SQLite store inside the PBIX. Your older Desktop doesn't recognize the newer schema, so it fails to read it and reports code=1

     

    2. Yes, that's it. The files that open are from colleagues on your version or older. The ones that fail are from newer builds.

     

    Fix: get everyone on the latest Desktop. Version drift across the team is the real problem, not the files.

     

    If this answer helped, please click 👍 or Accept as Solution.
    -Kedar
    LinkedIn: https://www.linkedin.com/in/kedar-pande

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
2 months ago

lh2275 

 

1. Power BI keeps internal metadata in a SQLite store inside the PBIX. Your older Desktop doesn't recognize the newer schema, so it fails to read it and reports code=1

 

2. Yes, that's it. The files that open are from colleagues on your version or older. The ones that fail are from newer builds.

 

Fix: get everyone on the latest Desktop. Version drift across the team is the real problem, not the files.

 

If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande