How to use Query Parameters in Visual of Power BI in Import Mode

[User00001]

Hi community,

I have requirement in which I have to fetch particular set of data from the MySQL database through the selected item in slicer. As we know MySQL doesnot support data to be loaded in DirectQuery Mode, so, I have only option of Import Mode. I have tried Query Parameters for dynamic selection of items but that requires Power BI Desktop, as in Power BI Service we have only option of typing but not selecting items, that too we have to do in Simentic Model. My requirement is that on Power BI Service, I should be able to change data based on the selection in the slicer in the Import Mode.

Any help, is greatly and deeply appreciated.

Thanks

[amitchandak]

@User00001 , You should load the full data in the Power query. Dynamic M parameter only works for direct query.

[User00001]

Hi Amit, Thank you for your suggestion.

Sorry, that I didnot mentioned earlier that data size is very large, which implies its infeasibility to load all data. Could there be a different solution possible?