Dataset selection in Power BI Desktop

[Cookistador]

Hello everyone,

I'm facing an issue with Power BI, and I would like to know if there is a way to achieve that,

I have different SharePoint Folder which contains the same files but with different value,

So in our example, take some country name, we would say:

-France

-Germany

-Mexico

So what I would like to acheive, it would be to let my user select a folder path (one of the country) and then return the required information depending on my user selection

Is there a way to achieve that directly in Power BI?

I know how to achieve that with Power Automate, but I would like to avoid to use Power Automate

Many thanks for your help 

[edhans · Accepted solution]

There are two ways to do this:

1. Import all of the data using the Combine Files feature in Power Query and then use a slicer in the report. When they select each country, only those values are shown.
2. If you only want that data in there, and you want to avoid Power Automate (which will not be an optimal solution as the latency between clicking a country and the report being ready - several minutes - will be brutal) would be to move that data to a Direct Query data source, like a Dataflow with the Enhanced compute Engine on.

I don't recommend #2 above.

What is your objection to doing #1 above?