Possibility of using parameter to dynamically change data source URL

[Anonymous]

I've searched around in the forum and couldn't find the answer...

I have a Power BI report that pulls data from an excel file. This excel file is stored in a SharePoint library. The business process requires that each year, we create a new excel file and accordingly, a new Power BI report. I want the user to be able to continue using the Power BI report by just copy and paste the URL of the new Excel file to, say a separate URL tracker excel file, and every new Power BI report will be able to pick up the right URL to that year's Excel file. Is it possible to assign the address of file source in Query Editor to be a variable and that variable's value comes from the Parameter? Thanks for any lead!

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the post below.

http://community.powerbi.com/t5/Desktop/Create-tables-based-on-all-Query-Parameters/td-p/345947

[Anonymous]

@v-chuncz-msft  The article changed my perspective of the solution and I was able to create some parameter that worked for my situation. Thanks!