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 ...
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
Deku
Super User
Super UserPlease 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?
- Deku
As you can see in Chris's blog, the dummy table is in import modem. The table to be filtered is in DQ