Database consistency check error when opening report

[chiran]

Hi, 

Im trying to open a power bi report on Powerbi desktop, but i'm getting a Database consistency check error: "Database consistency checks (DBCC) failed while checking the string store. An error occurred while loading Vertipaq data objects for multiple tables."

The report is not opening at all and i cannot change anything. 

The issue started today. Yesterday the report was working fine.

Anyone came across the same issue who can help me ?

 Thanks

[Anonymous]

Get the same error exactly when i open my report (pbix) . Uninstall bi desktop app and reinstall a new version of power bi desktop app. Error has still. How can i do and how to solve it?

[jasonnaylor]

I'm having the exact same issue as of 15/Feb/2023, successfully saved & closed my .pbix file and then tried to open it again ~30mins later and received this error. I've raised a new issue as suggested by the error popup, but unsure how to work around this... would love any tips or help if anyone out there can suggest something. (Clearing my permissions as suggested in the first response doesn't appear to help either ...)

[amitchandak]

@chiran , open data source setting (Under home tab-> Transform data -> data source setting)-> Clear permission and try again.

it may be because upgrade to Nov -2022, check for any issues - https://community.powerbi.com/t5/Issues/idb-p/Issues

[chiran]

@amitchandak Thanks for your reply. 

Note that i cannot even open the report on power bi desktop. It only gives me an option to cancel, then closes the power bi desktop

[fredrik_skarman]

Get the exact same error. Not possible to open the report. The report worked just fine without any error message. But after saved and closed, it was not possible to open the report again. No autorecovery versions of the file saved either. Have to start all over building the report from scratch.