Forum Discussion

snldevloper's avatar
snldevloper
New Member
2 years ago

Datamart update issue

Hi team,

 

Please see the below details. Getting this error while loading data into datamarts or creating new report from datamarts

 

Couldn't load the data for this visual

 

This operation is not allowed, as the database '1289089c-71a9-4df4-bacc-ee7e66369706' is in a blocked state. Please refer to https://go.microsoft.com/fwlink/?linkid=2159112 for more information.

 

Activity ID: 1847984d-2dc2-4462-bcfa-69246428730b
Request ID: 5e71be08-40d0-d61f-0972-5da5afc28b78
Correlation ID: d679e990-ca3f-9351-39f9-237c5a8cee4b
Time: Tue Aug 29 2023 20:39:17 GMT+0530 (India Standard Time)
Service version: 13.0.21401.70
Client version: 2308.3.15456-train
Cluster URI: https://wabi-south-east-asia-b-primary-redirect.analysis.windows.net/

 

Please help.

Need Help
Show and Tell

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi snldevloper ,

    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

     

    How to Get Your Question Answered Quickly 

     

    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.