Automate Sharepoint file as source for Power BI

[Anonymous]

Hello All,

I have been working on a Excel file which has multiple spreadsheets in it every month new spreadsheet is going to be added and I want to create a report which should get the updated data in existing spreadsheets and new sheet as well once added.

So, every sheet can be updated anytime, no fixed times and the business wants to see the changes immediately or possibly in a few minutes.

I need some guidance how can I do this whole thing dynamically.

It would be helpful if someone guide me with the requirement steps to do this job.

Thanks,

[negi007]

@Anonymous you can use sharepoint excel file as a data source in powerbi. YOu may refer to below links on how to use sharepoint files

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

https://www.youtube.com/watch?v=gJF2e_43FRY