topic Re: Dynamic Source in Desktop

Dynamic Source

Anonymous — Mon, 30 Nov 2020 10:54:58 GMT

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

Re: Dynamic Source

amitchandak — Mon, 30 Nov 2020 11:27:29 GMT

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

Re: Dynamic Source

V-lianl-msft — Wed, 02 Dec 2020 07:42:55 GMT

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.