Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago
Solved

PB Dataset with parameters

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?...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
Markzolotoy
Impactful Individual
5 years ago

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?