Dataset refresh transient issue w no specific details

[inforazborki]

Hi all,
The dataset i connected to a few excel sheets, one folder and an SQL Server Database (All Gateway conections are labeled as "Active").
I am getting this error while refreshing the dataset on PowerBI Service with no further details: 

Unable to connect to the data source undefined.

Please try again later or contact support. If you contact support, please provide these details.

• Cluster URIWABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
• Activity ID9910160f-81f5-4206-b0e9-400443f0f198
• Request ID8bfbef83-4a22-568b-d14f-d93fe282f97c
• Time2021-02-25 11:45:31Z
  
  
  Any suggestions are welcome!

[v-eqin-msft]

Hi @inforazborki ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @inforazborki ,

Please upgrade to the latest version of the gateway.

Basically steps for troubleshooting:

1. Make sure the gateway is online and is the latest version. (You can check your local gateway log or use fiddler to trace the operation logs)

2. Download the pbix file and refresh it in Power BI Desktop to rule out errors in the data source.

3. Change the Privacy Level/ Re-input the credentials. 

4. Reboot.

5. If you still cannot solve the issue,sorry for that, we do not found an effective solution.We suggest you go to https://powerbi.microsoft.com/en-us/support/ ,scroll down and click "CREATE SUPPORT TICKET" for further help if you are a pro user.

Refer to:

https://community.powerbi.com/t5/Service/Failed-to-refresh-datasets-import-List-ConformToPageReader/...

https://community.powerbi.com/t5/Service/data-gateway-cluster-and-failed-refresh-quot-Unable-to-conn...

https://community.powerbi.com/t5/Service/Unable-to-connect-to-the-data-source-undefined-azure-sql-in...

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[collinq]

Hi @inforazborki ,

When you get this message it is almost always on the back-end in the Microsoft side.  If you keep getting this, I would suggest copying that information from the message and opening a ticket and let Microsoft help you by searching their logs to determine what might be happening.