Forum Discussion

GerryFlanagan's avatar
GerryFlanagan
Microsoft Employee
10 years ago

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...
Need Help
bhmiller89's avatar
bhmiller89
Helper V
10 years ago

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

  • GerryFlanagan's avatar
    GerryFlanagan
    Microsoft Employee
    10 years ago

    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.