Forum Discussion
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 values (that are 2 fields the dataset) on the first page that would then filter the data in power Query. And then trigger a M function and the flattening will run only for that set of values.
Any ideas as as you how i can get the selected slicer values to be passed to the power Query dataset filtering ?
Or if there are ideas to use a different logic to flatten the hierarchy, that'll be even better.
Currently using this logic: Dynamically flatten Parent-Child Hierarchies in DAX and PowerBI –
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.
10 Replies
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
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.
Hi rp2022 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi rp2022 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi rp2022 ,
I wanted to check if you had the opportunity to review the information provided by lbendlin . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you
