Forum Discussion

lancea's avatar
lancea
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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi lancea ,

 

Based on your description, have you tried to create a parameter and then use it in the Advanced editor?

Please refer to the following threads.

Solved: Dynamically change data source of published report - Microsoft Power BI Community

Solved: Dynamically change data source - Microsoft Power BI Community

Power BI – Using Parameters for Flat File / CSV / Excel Sources - Reporting/Analytics Made easy with FourMoo and Power BI

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.