Forum Discussion
Pass table type parameter in stored procedure
Trish wrote:
Hi,
I have few questions :
I am using power BI desktop but stuck in few areas and its better if i get some help from you guys.
1) How to pass parameter to stored procedure from slicer- since i am doing some long calculations in procedure.
2) Is it possible to pass table type variable (user defined table type) in procedure in Pwer bI.
Thanks
Tri**bleep**
1) No
2) No
The only interaction between Power BI and Stored Procedure(say in MSSQL) is calling a stored procedure by running a exec yourSP as the SQL Statement when getting data from MSSQL database in IMPORT mode.
You can submit your ideas at Power BI Ideas and vote it up.
Many thanks for reply.
Few more questions:
Is it possible to pass parameters to sql procedure in power bi embedded.
Is it possible to pass table type parameters in power BI embeeded.
Also is there any dependency esxist betwwen the slicers in Power BI desktop or Power BI embedded.
Thanks
Trish wrote:
Many thanks for reply.
Few more questions:
Is it possible to pass parameters to sql procedure in power bi embedded.
Is it possible to pass table type parameters in power BI embeeded.
Also is there any dependency esxist betwwen the slicers in Power BI desktop or Power BI embedded.
No such a parameter feature in Power BI Embedded, not to mention pass any parameter. Parameter only provides the flexibity when developing a report in Power BI Desktop. When published to Service or uploaded to Power BI Embedded, you can see parameter any longer.
Slicer works the same way in Power BI desktop and Power BI Embedded.