This operation is not allowed, as the database '' is in a blocked state

[kezza04]

Hi,

After utilising free trial of premium per user we have now switched to organisational licence.  I am not sure whether this issue is related or not but we are getting the below error message when running a report

This operation is not allowed, as the database '' is in a blocked state

The setup currently is using

- gateway ( required due to private link setup)

- Azure SQL database

- power bi workspace

Thanks

Kez

[Guiconsani]

To anyone wondering if the redeploy it's really necessary, the doc below shows the limitation from migrating PPU to Premium, where you can´t make any future updates in the dataset/datamart

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-per-user-faq#considerations-an...

[v-xulin-mstf]

Hi @kezza04,

Could you provide more details about the issue?

Please check Privacy Level setting for the data source:

Please refer:

https://docs.microsoft.com/en-us/power-bi/admin/desktop-privacy-levels

Best Regards,

Link

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

[kezza04 · Accepted solution]

Hi Thanks for the responses.

We ended up totally redeploying the report which resolved this issue for us.

[v-xulin-mstf]

Hi @kezza04,

Congratulations, if the issue has been solved, please adopt your solution to help others.

Best Regards,

Link

[lbendlin]

can you access the database with a different tool (for example SSMS)?

[kezza04]

There are no issues with the database connectivity.