Forum Discussion

EmilyP's avatar
EmilyP
Frequent Visitor
4 years ago

Parameter Search not working in Power BI Online

Hello,

I am trying to understand the search box that shows within the published Paginated Report on Power BI Online.

On inital load, the search function works as expected. However, once the report is ran, when using the search function again it won't update the report and it will keep the previously selected parameter instead of using what is within the search. 

 

What can be done to make it so the user doesn't have the refresh the report everytime in order to search for a particular parameter. 

 

Thanks!

Paginated Report Builder
Paginated Reports
Search

7 Replies

  • sevenhills's avatar
    sevenhills
    Icon for Super User rankSuper User
    4 years ago

    I believe you are trying is below

    * Selected parameters and ran the report

    * After running the report, you changed the parameters (values)

    * To get the report updated/refreshed for the changed parameters, now you have to click this button

     

     

    Note:

    FYI, Paginated reports are nothing but classic SSRS reports. These are tuned to Power BI service. It is not like interactive BI reports, where it gets automatically refreshed. This is the default behavior. 

     

    • EmilyP's avatar
      EmilyP
      Frequent Visitor
      4 years ago

      Hello,

      I am able to use the search function / copy and paste a value into the parameter spot when I come into the report after refreshing within Chrome, but after the report has already ran once, when I go to search and select that new value and then click the View Report it doesn't update the report, it keeps the previously selected value. 
      Thanks!

      • sevenhills's avatar
        sevenhills
        Icon for Super User rankSuper User
        4 years ago

        Looks like tough scenario, without screenshots. Let us do some steps to diagnose further. In order to do this, let us pick three values for the (one) parameter you are searching.


        (A) Let us see the data for each value selected. This is to check the data exists for that parameter value.  You see the data for each value!

         

        all good!

         

        It is not the parameter value vs report data. it is purely parameter value passing.

         

        (B) Refresh the report, first time ~ fresh rendering, select two values of the parameter, run the report. After you ran the report, do this step. Click the file menu, click the generate link. Copy and paste in the notepad.

         

        (C) With your search step, select the third value and then click the run report button. let the repor run. After you ran the report, do this step. Click the file menu, click the generate link. Copy and paste in the notepad.

         

        Now, you can compare the two links and see whether the third value is getting added or not. If no differences, then there is some issue here. If you find the third value in the link, then try the (D)

         

        (D) Now take the link from (C) and run in new tab and see if there is all data coming or not.

         

        ... hope this lengthy approach will help you to identify the issue as data, parameter value, parameter selection and rendering the report.