Forum Discussion
Solved
Selected Slicer value as parameter to Filter Power Query table
I need urgent help. So, I have a huge dataset to which I implemented Hierarchy flattening. Now considering the size of the data the refresh takes forever. So, I want the users to select a set of valu...
Import your entire huge dataset. That is your only option.
They can do that - on the loaded semantic model.
There is no way they can dynamically re-import the data source based on filter choices. No. Way.
Dynamic M Query parameters are only applicable to Direct Query data sources.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
