Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pjr1221
Frequent Visitor

Passing Date Parameters to Mysql Stored Procedure By Power BI slicer

Hi all,

 

I am having struggle with stored procedure in Power Bi.

 

1. I want to call my stored procedure written in Mysql Server to Power Bi. Is it Possible?

>> call P_DC_REPORT_OVERVIEW_SALES('D', '20180810', '20180816');

 

2. Is it possible to pass parameters through the Power bi slider to the stored procedure of mysql?

 

Please provide your feedback.

I appreciate any idea..

 

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @pjr1221 

It should be possible.

Please refer to this blog:

Execute SQL Server Stored Procedure With User Parameter In Power BI

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

Hi @pjr1221 

It should be possible.

Please refer to this blog:

Execute SQL Server Stored Procedure With User Parameter In Power BI

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi @v-juanli-msft 

your blog link doen's not working

Hi @pjr1221 

Update!!!

Click again.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-juanli-msft hi,

i've already done this problem, But there is another problem.

If you know the answer, please leave a comment please.

 

Dynamic parameter invoke by slicer

 

Best Regards,

pjr1221

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.