SQL wharehouse do not work with power bi online service

andre_gonzalez
New Contributor

‎10-17-2023 01:37 PM

Whenever i try to use a SQL Wharehouse serverless cluster on a power bi dataset it does not refresh on the power bi online service. It does work normally for other types of databricks clusters. The catalog is being defined on the power query import.

I receive the following error:
[Microsoft][ThriftExtension] (38) An attempt was made to set an empty string as the current catalog. This type of operation is not allowed

2023-10-17_14-36.png

0 Kudos

karthik_p
Databricks Partner

‎10-20-2023 08:57 AM

@andre_gonzalez which version of power BI desktop are you using, is that Desktop version 2.98.683.0 . to use UC we need to be on above version

karthik.p
0 Kudos

ChuckyDee25
New Contributor II

‎11-08-2023 12:04 PM - edited ‎11-08-2023 12:05 PM

Hi,

We have the exact same issue, even if we specify the catalog in the connection parameters.

However, Oauth authentication through a dataflow (instead of from Power Query Desktop) works fine. In Desktop we are in version 2.122.746.0, but the issue is only present in Power BI Service

0 Kudos

GabeWerpel
New Contributor II
In response to ChuckyDee25

‎06-18-2025 04:08 PM

Was having the same error, but added the catalog (which is highlighted as optional) as well for the connection and it worked.

0 Kudos