Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

lagacem

Can't Refresh Excel through On Premise Gateway Unable To Connect Undefined

Submitted by on ‎10-06-2021 03:52 AM

I have multiple Excel refreshes that all work perfectly fine. This new one, using the same creds and Gateway as all the others, fails within a few seconds with. I have tried putting the data source to Organizational or even Public and same with the Gateway but nothing seems to get it working

 

lagacem_0-1633516243273.png

 

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
TDouglass
Frequent Visitor
‎10-06-2021 05:58 AM

Hi LagaCem,

Can i send you a personal message about setting up scheduled refreshes with Excel and the gateway?  Is your excel on a server?  If so, where is your gateway installed?  I have a user that is trying to get a scheduled refresh and we are having issues.

lagacem
Frequent Visitor
‎10-06-2021 07:24 AM

Hiya,

 

The Excel is on a OneDrive and the Gateway is installed on a Desktop Machine that's always on at our office.

 

Thanks

v-robertq-msft
Community Support
Community Support
‎10-06-2021 07:02 PM

Hi,

According to my research, I think you can try these methods to check if the dataset refresh can succeed: 

  • Set Privacy Level to Organizational
  • Made sure all reports are refreshed at different times
  • Created another on-premise gateway to split the load
  • Created database tables rather than views to reduce processing between PowerBI and MSSQL
  • Ensured both desktop and gateway has the latest version installed at all times

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses