Solved: Re: Calling a DB Stored Procedure from PBI Desktop

RichFlorida · ‎11-08-2021

Hello All,

Does PowerBI Desktop support calling a database Stored Procedure and capturing the returned value(s)?

How about from Report Builder?

The procedure could be an Oracle or SQL procedure.

Please advise!

AlexisOlson · ‎11-08-2021

Yes. Both Power BI and Report Builder can call stored procedures assuming the user has appropriate database permissions to run them.

More details:
https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

https://community.powerbi.com/t5/Desktop/How-to-use-a-SQL-Server-Stored-Proc-with-no-parameters-as-a...

https://stackoverflow.com/questions/37589448/how-to-use-sql-server-stored-procedures-in-microsoft-po...

View solution in original post

CNENFRNL · ‎11-08-2021

Sql.Database("LAPTOP-2CM98V85\MSQLSVR", "BikeStores", [Query="EXEC dbo.uspFindProducts 100,1000"])

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!