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?

 

Thanks

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    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.

  • 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?

  • Markzolotoy's avatar
    Markzolotoy
    Impactful Individual
    5 years ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.