Showing results for 
Search instead for 
Did you mean: 

Enterprise Gateway refresh for a data set connecting to a SQL server and One Drive Excel file

The situation is that I have saved a pbix file to the one drive group for the service group workspace. I imported that pbix file into the group worskpace and set up a connection through an enterprise gateway to the SQL server data source. I have recently updated the pbix file and it now contains an excel file which I have also saved to the group one drive. Since including the excel file the refresh no longer works. I have tried adding the excel file as a web source and a file source on the enterprise gateway but neither work. Has anyone else come across this problem? 


Hi @GerryFlanagan,

You don't need the Enterprise Gateway for the Excel file if it's on a OneDrive. 
What errors are you seeing? 
Here's a link about using the PBI file in OneDrive:


@dimazaid @GerryFlanagan did either of you figure this out? Currently running into the same problem.  Have a power bi file and can't set a refresh schedule because the Excel file included in the data is on One Drive for Businses.  The enterprise gateway won't allow a refresh to be set up

@bhmiller89 I'm afraid not, I ended up breaking the excel file up into smaller tables and including directly in the pbix file with the "enter data" function. The refresh for the  excel file was very infrequent so this solution was managable for me but if the data in your excel is updated regualrily then this would be a real pain.



The data set is also pulling data from a SQL server DB, which seems to be the thing thats causing the automatic link between one drive and power BI to break. I've got data sets that only pull from on files on one drive and there's no problem connecting.




Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors