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.
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**
@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.
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**
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 |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |