Forum Discussion
Direct Query Based On User Input
Hello!
I am relatively new to Power BI and have not had any major difficulties so far except for the usage of Direct Query. I have a very big table that I import from Denodo and want the user to be able to input the phone number for example in some kind of text filter box or slicer and have that trigger a direct query to fetch the data that are only relevant to that input (Where phone_number = input) and the data has to be live up to date data. When I search on the possiblity of doing that all results refer back to dynamic m query which I have tried but data and visuals keep loading until it times out so I was thinking maybe that is not the ideal way to go about it. I just need to know if achieving such a thing is possible and what are my options. Thank you!
Please see blog post on pass arbitrary values through dynamic M parameter
Think this is your only option. Just need the source to optimized for the queries
3 Replies
Please see blog post on pass arbitrary values through dynamic M parameter
Think this is your only option. Just need the source to optimized for the queries
Hello Deku
Thank you for the reply!
I followed the tutorial you provided but cannot create a blank query for the dummy table... I get the following pop-up message:
I am using Denodo and it worked when i chose direct query for my table but not for the blank query... any idea if there is another way for that part?
As you can see in Chris's blog, the dummy table is in import modem. The table to be filtered is in DQ