Forum Discussion
GerryFlanagan
Microsoft Employee
Microsoft EmployeeEnterprise 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...
dimazaidMicrosoft Employee
Microsoft EmployeeHi 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: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-desktop-file-onedrive/
GerryFlanaganMicrosoft Employee
Microsoft EmployeeHi,
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.
Regards,
Gerry