topic Pass table type parameter in stored procedure in Developer

Pass table type parameter in stored procedure

Trish — Fri, 07 Apr 2017 21:56:14 GMT

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

Pass Table type value in stored procedure and iframe issue

Trish — Fri, 07 Apr 2017 22:09:08 GMT

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

Re: Pass table type parameter in stored procedure

Eric_Zhang — Mon, 10 Apr 2017 07:35:06 GMT

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

Re: Pass table type parameter in stored procedure

Trish — Fri, 14 Apr 2017 00:03:52 GMT

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

Re: Pass table type parameter in stored procedure

Eric_Zhang — Tue, 18 Apr 2017 02:31:35 GMT

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