szymon_dybczak
Esteemed Contributor III

Hi @carlos_tasayco ,

 According to docs:

“Any workspace migrated from a PPU environment to a non-PPU environment (such as Premium or shared environments) must have its datasets refreshed before use. Reports opened after such migrations without being refreshed will fail with an error like: This operation isn't allowed, as the database 'database name' is in a blocked state. You might need to do a full refresh through SSMS to fix this.” 

Also following LinkedIn post confirms this behavior: 

18How to fix the “Database is in a blocked state” Semantic Model error message after migrating to a Fabric capacity
https://www.linkedin.com/pulse/how-fix-database-blocked-state-semantic-model-error-message-cantu-r3e...

Solution 

After migration you need to perform full refresh. So, either ask your admin to do that for your or if you have enough permission on workspace you can try to do it yourself. 

If my answer was helpful please consider marking it as accepted solution

View solution in original post