Forum Discussion
Direct Query with Parameter to SQL
I'm saying that you don't have to parameterize it yourself. With DirectQuery, Power BI will automatically query your SQL source using the filters you've applied as part of the query.
I'd recommend this article for more detailed information on DirectQuery:
https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages
I am sorry, but I just don't understand. Here is a very simple sample file. (CustomerID = Referral_ID). How do I make the value of the slicer as my Referral and have my direct query use that as a parameter for the SQL call? AlexisOlson
https://mwtn-my.sharepoint.com/:u:/g/personal/dkernen_mwtn_org/ERhNpctEl3lCr47sFvB6fC0BG8l0B6ezoU4ZkQeJiWhhHQ?e=baWxXk
Hi
Have you got the solution for this? I have also same requirement. I can't load the full fact table due to huge volume. Hence I want that to be in direct query mode where say product filter will have a product_parameter which will run the query based on that product_parameter value selcted by the user at front end.
I have showed the parameter product_parameter as filter slicer (show as value), now whatever value user will select in that filter , i want that value to passed to the direct query on the fact table and fetch the data for that filtered value.
Any help please on this.
Many Thanks
Ani