Forum Discussion

Helper I

5 years ago

Solved

Automatically change Excel Data Source monthly

I have created a Power BI report that has a dashboard for monthly data. Data comes from an Excel file uploaded in SharePoint, named "Monthly Report - May 2021". Every month, a new file is uploade...

Need Help

Tips and Tricks

Tutorial Requests

amitchandak
5 years ago
lancea , You can try the folder approach?

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711

amitchandak

Super User

5 years ago

lancea , You can try the folder approach?

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711

lancea

Helper I

5 years ago

The second link worked fine, thanks!

Forum Discussion

Automatically change Excel Data Source monthly

Related content

Monthly Automatic Change

Latest Monthly Value measure that resets automatically

Does data cleaning automatically happen monthly?

Import monthly data automatically

PowerBi Monthly Automatic Update Status