Showing results for 
Search instead for 
Did you mean: 
tera12 Regular Visitor
Regular Visitor

"report server" refresh data



I am having a problem with a few reports refreshing.  I added the same Excel document to each of these reports that contains information needed for the reports that I could not pull in from other sources.  I was initially able to add the Excel document as a Datasource to the Gateway Clusters, but our server went offline for a few moments and since then I cannot re-establish the connection successfully to this Excel file.


Is there some trick I am missing? 


I have a ton of reports that are connected to an SS-ERP gateway - I do not use a personal gateway because it will cause my other reports to fail.  All reports connected to the gateway are refreshing with no problem.  My only issue is the reports with the Excel tables included.


The error message is below.  Thanks for any assistance.



Error Message.PNG

v-fengyz-msft Frequent Visitor
Frequent Visitor

Re: "report server" refresh data



Can you try to connect to the Excel file locally?


Is there any changes on your all clients which Gateway installed? 


Try to reconfigure the datasoure for the GateWay  Cluster and re-install Gateway on the computer which may has issue.


A few tips for troubleshotting connectivity with the On-Premises Data Gateway on Power BI for your reference:


Troubleshooting connectivity


Check what happens.




Pirlo Zhang


Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 299 members 3,971 guests
Please welcome our newest community members: