Forum Discussion
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 Power.bi service group workspace. I imported that pbix file into the group worskpace and set up a connection through an e...
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.