PB Dataset with parameters

[Markzolotoy]

I am creating a dataset for a paginated report. Dataset has one query that uses parameters. When I get that dataset into Report Builder and create a report dataset how can I provide these parameters?

Thanks

[V-pazhen-msft · Accepted solution]

@Markzolotoy 

I am thinking if you move the report from ssrs to pbirs, and "edit in Power bi desktop". You can have your parameter in power bi desktop for rs, then publish this pbix to power bi report service. 
Solved: Move SSRS reports to existing PBIRS - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Markzolotoy]

Also when you say refresh the dataset can that be done automatically when a user is about to run the report? If not, what about when a scheduled report export is about to run?

[Markzolotoy]

Here is what I am trying to achieve. I am converting a SSRS report into a paginated report that will be run on the Service. The data is stored on-prem server and will be accessed via the Gateway. In order to get this data into a paginated report I am creating a PB dataset. The dataset is based on an SQL stored proc. Execution of which takes two parameters. What would the right approach be?

[parry2k]

@Markzolotoy you cannot provide the parameter to the Power BI dataset from the Power BI report builder. You have to first refresh the dataset in Power BI Service by entering the value of the parameter. Not sure what you are trying to achieve here, not sure if this is the right approach.