Using Excel File as a Datasource

[Anonymous]

Hi, 

I have an Excel file on which i want to create a report and this excel will be updated from time to time, i want the data in the report to refresh also.

Which is the best approach in this case? Put the file on Power BI Service, on SharePoint, etc?

Thank you,

Ioana

[v-danhe-msft]

Hi @Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

You could refer to NickNg278's solution to configure a gateway, also you could put your files on Sharepint or OneDrive, you do not need to configure a gateway for your files:

https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive

Regards,

Daniel He

[Anonymous]

@Anonymous,

You can install gateway to schedule your data refresh in Power BI 

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem