Databricks Community

sumitkumar_284 · yesterday

I am trying to refresh Power BI Dashboard using Databricks jobs and constantly getting this error, but I am providing optional parameters which includes catalog and database. Also, things to note that I am able to do refresh on Power BI UI using both Virtual Network Data Gateway and Data Source Credential.

Error after running Databricks jobs:
Run failed with error message System error occurred during execution of task Power BI Task: Semantic model update succeeded but refresh failed with error: [Microsoft][ThriftExtension] (38) An attempt was made to set an empty string as the current catalog. This type of operation is not allowed. The exception was raised by the IDbCommand interface. Table: joiners. Partition: joiners.

Best Regards,
Sumit Kumar

szymon_dybczak · yesterday

Hi @sumitkumar_284 ,

Can you provide us more details? Are you using Unity Catalog? Which authentication mechanism you have? In which version of Power BI Desktop you've developed your semantic model/dashboard? Do you meet all below requirements?

Publish to the Power BI service from Azure Databricks - Azure Databricks | Microsoft Learn

Power BI task for jobs - Azure Databricks | Microsoft Learn

sumitkumar_284 · yesterday

HI @szymon_dybczak

1. Yes, we are using UC.
2. Authentication method: OAuth(u2m)
3. Power BI Desktop Version: 2.143.1204.0
4. Yes, we confirm that all the requirements mention in the docs are met.

The error specified doesn't mention whether this needs to be resolved in Power Bi or Databricks, but I can confirm that I am able to refresh the reports form Power BI Service and Power BI Desktop but not from Databricks JOB.