Unable to connect to data source undefined

[TMELN21]

Hi, I am having issues refreshing my data on PBI online with the following message coming up when trying to refresh my dataset

"Unable to connect to data source undefined"  

• Cluster URIWABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net
• Activity ID7dcceefa-1cc9-4198-a09b-812ec3638f03
• Request IDf9e63a38-af5a-df5f-28f4-2435d627c6a2
• Time2022-01-19 13:56:09Z

I have tried various fixes such as privacy level settings, database name check, re-installing gateway, using only one data source.  Under settings>gateway>Data Source Settings I get the message that the connection is succesful but again when I go to refresh i get that same error "Unable to connect to data source undefined".  I have been trying for a number of days now and have totally hit a brick wall, any help would be greatly received.

[Icey]

Hi @TMELN21 & @J-MJE ,

Please give me some information to help research the issue:

1. What's the version of your Power BI Service and Gateway? Have you tried the latest version of gateway?

2. What's your data source and the privacy level? Are all data sources the same privacy level?

3. Is this issue with all reports' refreshes, or just this one? 

4. Is the workspace involved classic (v1) or new (v2)? Have you tried both v1 and v2?

5. What's the license mode of your workspace?

6. Have you tried to delete and re-add the data sources in gateway?

7. When did this issue appear? Did you make any changes before or after it occurred? 

Best Regards,

Icey

[TMELN21]

Hi @Icey 

1. Current version of Gateway is 3000.110.5, Current version of PBI Desktop is 2.100.1401.0, Current version of PBI Service (not sure where to find this)

2. Data source is SQL and Privacy level of "Public", only have the one data source currently.

3. I have the same issue with another report

4. The workspace involved is V2, I havent used the V1

5. License mode for the workspace is Pro

6. Yes I have tried deleting and adding the data sources in the Gateway

7. Issue appeared December

Thanks for your help

TM

[J-MJE]

Hello Icey,

I am not sure exactly what was changed or fixed, but later in the day everything began working again. I'm assuming it was probably something on my side somehow.

Thanks

[Icey]

Hi @J-MJE ,

Anyway, glad to hear the issue is gone.

@TMELN21 How about yours?

Best Regards,

Icey

[J-MJE]

I'm experiencing the same error. I can also confirm that the gateway does not seem to be an issue, as all of my powerapps that are running on the same gateway are working fine.