Direct Query Based On User Input

[Anonymous]

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!

[Deku · Accepted solution]

Please see blog post on pass arbitrary values through dynamic M parameter

https://blog.crossjoin.co.uk/2023/01/29/passing-any-arbitrary-value-from-a-power-bi-report-to-a-dyna...

Think this is your only option. Just need the source to optimized for the queries 

[Anonymous]

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? 

[Deku]

As you can see in Chris's blog, the dummy table is in import modem. The table to be filtered is in DQ