Forum Discussion
Refresh excel from OneDrive and Sql Database
Hey, i've created a report with an excel file on onedrive as a data source and a sql database as another source (data import). i was able to setup data refresh only when each source is the only ...
I couldn't make it work yet. We decided to just import the table from the excel to PowerBI via the "import Data" function, because the data from the excel will not change so often.
When i put the excel for example on a fileserver, how do i have to configure the gateway to refresh from this file server? And will it then work with the sql on-prem sql server?
There would be still two completely different data sources.
Hi NerdFlanders,
When storing Excel on onedrive , I can use personal gateway to refresh the dataset. Have you tried personal gateway?
In addition, if you persist to use on-premises gateway, you would need to add Excel data source under the on-premises gateway after you move Excel to on-premises environment.
Thanks,
Lydia Zhang