Forum Discussion

planzel's avatar
planzel
Regular Visitor
10 years ago

Issue when switching pages for report level filters

When we apply a report level filter on a report page, then switch to another page in the report, it appears that the filter is not applied.  The report level filter remains checked but it takes a click of the Refresh button to refresh the page and get the filter applied.  Shouldn't the filter/refresh apply automatically to all pages when using a report level filter?

 

This doesn't appear to happen in Power BI Desktop.

 

We are using a direct connection to an on-premise tabular model, using enterprise gateway.

Need Help
Show and Tell

6 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    planzel I replicated your scenario by using directquery to sql server and then published the report. In powerbi.com I edited report and added report level filter. I didn't see any issues and it did filtered all the pages in my report.

     

    Below is my guess about what might be happening in your case.

     

    1) Since you're using DirectQuery it actually connects on-prem and filters data therefore you need to wait a little for pages to be filtered. Look for dotted spining circle. 

     

    2) Ensure your tables on-prem are connected therefore when you apply filter to one page data represented on second page has relationships that will fitler it.

     

    3) Switch to import if can.

     

    Do let me know if any of above works for you.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    planzel Yes, the filter should apply right away. Have you experianced slowness in other aspects of working with your model? Is this new behavior to an existing report, or are you seeing this in a new report as you build it?  I have experianced some slowness when initially creating a report for the first time, but things even out pretty quickly. If this is on an existing report, and consistently happening, I'd file a bug.

  • planzel's avatar
    planzel
    Regular Visitor
    10 years ago

    Thank you for the replies.  I don't think that model issues or slowness are the problem.  The filter works as expected on the 1st page; on the 2nd page the datasource is the same but the page does not refresh at all until we manually hit the Refresh button.

     

    If you still believe this could be a bug, is there a suggested link for reporting it?

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      10 years ago

      Hi planzel,

       

      Based on my test, if the report uses SSAS on-live connection, when we change report filter condition on first page, other pages will also updated with this filter condition. It seems that I'm not able to reproduce the issue.

       

      If you believe this is a bug, you can submit a idea in the Power BI Ideas forum.

       

      Best Regards,
      Qiuyun Yu

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        We are seeing the same effect here.  We also use an on-premise SSAS tabular cube.  Clicking refresh solves the problem but can cause potentially dangerous effects if the user thinks they are seeing data which is actually unrelated to the filter they set