Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Starting yesterday most of our Power BI report refreshes are failing with the following reason. This is happening to multiple reports in the workspace. The report refreshes used to work perfectly till now.
Internal database error: Library used incorrectly. SQLite Error Code=21. An error occurred while attempting to insert a row into the system table 'Table' in the metadata database.
The data source is SQL Server 2016. Any idea why this could be happening?
The workspace is on P1 capacity. The reports refresh fine on desktop.
Thanks
Hi @Anonymous,
I think you are working with SSAS data source and third party sqlite connector, right?
If this is a case, I think this issue should more related to sqlite itself, you can post to sqlite related forum to get better support.
In addition, you can also take a look at following link with same error message:
Unable to Deploy Cubes - Error : Failed to save modifications to the server. Error returned: 'Internal database error: Library used incorrectly. SQLite Error Code=21. An error occurred while attempting to delete a row from the system table 'Table' in the
Regards,
Xiaoxin Sheng
I'm having the same problem. I would appreciate any answer
HI @Anonymous,
Is there any update on your sql server environment? I can't reproduce this on my side, it works when you test with sql 2016.
Can you please open a support ticket to get better support from power bi team? It is free for pro and above licenses.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.