from PPU to Premium Capacity P1 error

[MrMP]

Hi everyone,

We have been using PPU licences and developed Dataflows and reports in our organization.

Now we have swiched from PPU licences to P1 Premium capacity and changed it for all the workspaces.

The only error we are encountering is that some reports are using Analysis services connection to other reports and that is crashing for error:

DataSource.Error: AnalysisServices: This operation is not allowed, as the database 'xxxx-xxxx-xxxx-xxxx-xxxx' is in a blocked state. Please refer to https://go.microsoft.com/fwlink/?linkid=2159112 for more information.

Any ideas why this is happening?

Thank you!

[Anonymous · Accepted solution]

Hi @MrMP ,

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.

Power BI Premium Per User - Power BI | Microsoft Learn

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.