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