Forum Discussion

DataVizGuy's avatar
DataVizGuy
Advocate I
3 years ago
Solved

Paginated Report not Cross Filtering

Hi,

 

I am trying to insert a Paginated Report and have it repsond to slicers that I have in my dashboard, however when I insert the report, it is showing all rows in my table by default. For reference, I am running this off of a single table with no measures and have set up the report with the exact same parameters/slicers that I am using in my dashboard. Strangely, when I hover over the Filter icon of my paginated report, it says my slicer selections are being applied, but the report does not show this.

 

Any ideas why this could be??

 

Appreciate the help in advance!

  • After meeting with Microsoft's support team I finally got this issue resolved (I believe). Had to create a new workspace (could not convert current workspace to premium with PPU trial), and then had to set up parameters associated with my slicers in both Power BI Report Builder and again in Power BI Desktop when connecting to the Paginated Report.

4 Replies

  • After meeting with Microsoft's support team I finally got this issue resolved (I believe). Had to create a new workspace (could not convert current workspace to premium with PPU trial), and then had to set up parameters associated with my slicers in both Power BI Report Builder and again in Power BI Desktop when connecting to the Paginated Report.

    • MallikarjunaBan's avatar
      MallikarjunaBan
      Helper III

      Hello DataVizGuy   how to avoid Object reference not set to an instance of an object.  in report builder while running and i have seen lots of articles about integration but none of them working some server connecting missing let me know thanks

  • v-jingzhang's avatar
    v-jingzhang
    Community Support

    Hi DataVizGuy 

     

    You may try turning on the "Auto-apply filters" option in Format pane. By default, this option is turned off. 

    • Select your paginated report visual. From the Format pane, turn Auto-apply filters on.

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

  • deosnt apply its not working can any one let me know i am getting Object reference not set to an instance of an object in report builder while running how to generate parameters