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

1903Johnson's avatar
1903Johnson
New Member
2 months ago

Troubleshooting steps

To narrow it down:

  • Compare the Power BI Desktop version on:
    • your PC
    • a PC where the file opens
    • the author's PC
  • Update your Desktop to the latest monthly release.
  • Download the PBIX directly from SharePoint instead of Teams.
  • Copy the PBIX to a local folder (for example, C:\Temp) before opening.
  • Try opening a zipped copy provided directly by the colleague.
  • Check the Power BI Desktop trace logs (File > Options and settings > Options > Diagnostics) or the logs under the Power BI Desktop tracing directory for a more specific SQLite message.