Pass table type parameter in stored procedure

[Trish]

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**

[Eric_Zhang]

---

@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.

[Trish]

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

[Eric_Zhang]

---

@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.

[Trish]

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.

3)How can i embed iframe in aspx page and also i can not make fit to width.
 
Thanks
Tri**bleep**