Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to be able to execute a stored procedure based on the input parameters selected by end user.
If we have to create a table , it is going to generate several million rows. Hence, we want to dynamically get user input and fetch only a subset of this. Please suggest.
Thanks for your help in advance!
Solved! Go to Solution.
Hi @DeepaS - the first option is possible using the correct syntax. Here are couple of blogs to consider.
Power BI Dynamic M Query Parameters Reloaded – Prologika
We are having function1 to feed data for Page1 and function2 to feed data for Page2. When we drill through from Page1 to Page2, the transient filters are displaying correct values but the data is not filtered in Page2 based on Page1 filters ( transient filters). Please suggest.
Thanks,
Deepa
Hello Daryl,
Thank you very much for your response. The Function worked for us. Appreciate your time 🙂
We used this site as suggested by you.
Hi @DeepaS - the first option is possible using the correct syntax. Here are couple of blogs to consider.
Power BI Dynamic M Query Parameters Reloaded – Prologika
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.