Forum Discussion

inforazborki's avatar
inforazborki
Regular Visitor
5 years ago

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 o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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/td-p/1493186/page/2

https://community.powerbi.com/t5/Service/data-gateway-cluster-and-failed-refresh-quot-Unable-to-connect/m-p/1662238

https://community.powerbi.com/t5/Service/Unable-to-connect-to-the-data-source-undefined-azure-sql-insert/m-p/1508936

 

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.