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?

PowerBi Monthly Automatic Update Status

Import monthly data automatically