Dynamic Source

[Anonymous]

Hi @needhelp  

I have built a reporting model, the source for which is an monthly extarct in excel format, source formating is same in all monthly extracts. I use 2 of these extracts for my report, reporting month and comparison month (for comparision). I have placed them in 2 different sharepoint folders 'Reporting Month' and 'Comparision Month'

Now every month when I get the extract I replace the source files and refresh the report.

But I need something where user can choose the source files from inside the report.

All the source files will be placed in the sharepoint folder, and I need a simple interface where user can themselves change the 'Reporting Month' file and Comparision Month' file from a simple dropdown, the dropdown should reflect all the files it the sharepoint folder, can this be achived?.

Regards,

Faraz

[V-lianl-msft]

Hi @Anonymous ,

You can refer to this blog:

https://radacad.com/get-the-list-of-folders-only-in-power-bi-using-power-query 

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

[amitchandak]

@Anonymous , I doubt from slicer -

But refer if this can help

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters