Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
v-eqin-msft
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

v-eqin-msft
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
Super User

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.