cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
inforazborki
Regular Visitor

Dataset refresh transient issue w no specific details

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!
3 REPLIES 3
Eyelyn9
Community Support
Community Support

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

Eyelyn9
Community Support
Community Support

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
Super User II
Super User II

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors