Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone!
I am trying to get data using parameterized SP in power bi direct query by using openrowset. is there any other way to get data instead of openrowset. Why? because it wants to open ad hoc distribution.
Thanks
SQL serevr
What's the actual data source? A CSV file?