cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

refresh power BI without premium, fabric instead

carlos_tasayco
Contributor

I have a job where I am refreshing my power bi semantic model, now my commpany change the workspace from Premium to Fabric, I am receiving this error message:

Run failed with error message System error occurred during execution of task Power BI Task: Semantic model update succeeded but refresh failed with error: This operation is not allowed, as the database '331d9e06-c39c-4f9d-864b-26fa2ec2469d' is in a blocked state. 

Genie is telling me the error is the following:

Why this happened:

  • PPU → XMLA Read/Write is ON by default → Databricks API refresh works ✓
  • Fabric Trial → XMLA Read/Write is OFF or Read Only by default → API refresh blocked ✗

Once XMLA is set to Read/Write, re-run the job and it will succeed. If you switch back to PPU temporarily, it will also work immediately.

Do you know if this is true? I am not an admin of power bi workspaces in my organization.

0 REPLIES 0