Passing Date Parameters to Mysql Stored Procedure By Power BI slicer

[pjr1221]

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

[v-juanli-msft · Accepted solution]

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.

[pjr1221]

hi @v-juanli-msft 

your blog link doen's not working

[v-juanli-msft]

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.

[pjr1221]

@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