Forum Discussion
Import files once, never load them again
Anonymous,
The "include in report refresh" option only has effect on Power BI Desktop report, it will not affect the refresh in Power BI Service.
When you combine online data source(Azure SQL database) and on-premises data source(Excel file) in a single dataset, gateway is required to refresh the dataset, and it is not possible to refresh specific data source in this single dataset. If you don't want to use gateway and want to set schedule refresh, you can upload Excel file to OneDrive, then connect to the Excel in Power BI Desktop.
Regards,
Lydia
Anonymous,
The "include in report refresh" option only has effect on Power BI Desktop report, it will not affect the refresh in Power BI Service.
When you combine online data source(Azure SQL database) and on-premises data source(Excel file) in a single dataset, gateway is required to refresh the dataset, and it is not possible to refresh specific data source in this single dataset. If you don't want to use gateway and want to set schedule refresh, you can upload Excel file to OneDrive, then connect to the Excel in Power BI Desktop.
Regards,
Lydia
Thanks Lydia, that worked!
I found it a little tricky to get it done, but to other who are reading this and have the same problem:
1. Upload your files to your workspace files in power bi (go to power bi web -> workspace -> files and upload them there)
2. In Power BI Desktop, change the source for your flat file queries to the web URL (find the web URL here)
3. Apply changes, re-publish your dashboard
4. Finally, in settings, make sure you use OAuth to establish a connection to each of the files individually. Once done you should be able to set a refresh schedule