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
Anonymous
Not applicable

Pass parameter to SQL Stored Procedure query from Slicer

Hi all,

As the title, we are now facing a problem with the data source. We have a stored procedure which required a parameter is YEAR, because we need to filter the data by Year before showing on the report/chart. 

We found that Power BI has Parameters management already but I'm not sure this can work with Slicer?

We really need help to select a year from Slicer and then reload all the data from the database.

 

Thanks in advance.

7 REPLIES 7
JosefPrakljacic
Solution Sage
Solution Sage

Hi @Anonymous,

 

the way you imagine it will not work, because the slicer is 'active' after PowerQuery is executed and "you can't get back".

 

What you can do is when the user opens the report he has to enter a year parameter.

 

To do this, I'd like to refer you to this article. This is about entering a username and receiving the data but the principle is basically the same.

 

I don't see any more elegant way to accomplish this.

 

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef

Anonymous
Not applicable

Thank you so much @JosefPrakljacic,

It's really helped me out when I need to change the data from DataSource.

But it just requests the Parameter when Open the PowerBI Template file with Power BI Desktop, can we apply it with the Power BI Web? 

Hope to hear from you soon.

Hello,

As far as I know about passing parameter values on the web(service); you can only do it in the dataset settings. You will have to give user access to the dataset inorder for the user to be able to enter the parameter value. I don't belive so far there is a way to have user enter the parameter value in the report and get the data, I wish power bi will update such requirements in the future updates. We really need that option enabled.

In the sementic model, the user need to go to the schedule refresh icon, go to parameter section and you will have option to enter the parameter value there, then apply. After that, they need to manual refresh the dataset inorder for the the parameter to take effect. Hope this information helps.

pthapa_0-1706905582633.png

 

Thanks,

Pthapa

Hi @Anonymous ,

Have you solved the problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, free to ask.

Best  Regards,

Cherry

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

Hi @Anonymous ,

Normally, we could edit parameter setting in power bi service.

Please refer to this document.

Best  Regards,

Cherry

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

Is there a way or workaround that report users will enter the parameter value in the report visual instead of doing it in the settings, sementic model?

Allowing users to access sementic model is not the best approach.

Thanks,

Pthapa

Hey does this meet your requirement?

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.