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.
Hello,
We have an on-prem SQL Server db - use gateway to connect. We would like to leverage the stored procs we have and dynamics call those based on slicer values - and other filters we have on a report. Is this possible? If so, could someone please show an example?
Thanks,
Dan
Solved! Go to Solution.
I'm not sure that feature is out just yet.
I'm not sure that feature is out just yet.
This is generally not possible. You can consider a Direct Query connection where each user interaction results in a new query to the data source but that requires tables or views at the other end. Maybe you can convert the stored procedure into a view?
If you want to go really crazy you can try to do this via R scripts. But that would limit your visuals options.
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.