I have tried Databricks job task to refresh power bi dataset and I have found 2 issues.
1. I set up tables in Power BI Desktop using Import mode. After deploying the model to Power BI Service, I was able to download it as an Import mode model. However, after running the first Databricks job with a Power BI task, I could no longer download the report in Import mode—only as a copy with a direct connection. I suspect this happened because the Databricks job modified the Power BI model via XMLA.
Databricks job setup
2. I was unable to refresh a Power BI model that included a Rename Column step in Power Query. When I removed this step, the refresh completed successfully.
Error message:
Column month_number was renamed in the Power BI Desktop (Transform data - Steps) to Month Number.
Does anybody have the same experiences? Is there any workaround for this?
Thanks
Hi,
1. In your job did you update the power bi query mode to import mode before you ran it?
2. If changing to import mode doesn't fix this issue, have you tried renaming in the semantic model rather than in the transform data steps?
Databricks job contains just one task.
There is only one source of the data - view based on delta lake table in Unity Catalog.
Cluster is serverless sql warehouse.
This is the result of the job:
Problem solved. I was downloading report instead of dataset. When I download dataset and open it, the connection is still Import mode.
