Forum Discussion
Dataset selection in Power BI Desktop
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
There are two ways to do this:
- 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.
- 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?
1 Reply
There are two ways to do this:
- 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.
- 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?