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 stored procedures made for our mobile and paginated reports and we would like to use them with PowerBI. The procedures often have temp tables and parameters. I've enabled opequery on our database, however I'm getting an error as show below. How can be stored procedure used to get data in PowerBI? Any help would be appreciated.
Details: "Microsoft SQL: The metadata could not be determined because statement 'SELECT ROW_NUMBER () OVER (PARTITION BY a.MonthBack ORDER BY sum(a.ApprovedLoanAmount) DESC)
AS' in procedure 'MR0001_MosRanking' uses a temp table."
I've found there're basicaly 3 ways how to utilise stored procedure in Power BI:
It seems, the most straightforward way is to execute variable which stores stored procedure call, however I'm having some troubles in doing so.
Hi @SJi,
Thanks for your sharing.
Regards,
Yuliana Gu
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.
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |