Forum Discussion

Vanchy_Liao's avatar
Vanchy_Liao
Icon for Advocate IV rankAdvocate IV
1 year ago
Solved

Data limit feature is not working after deploying to PBIRS

Hi,

    I implement new feature "Data limit" function to my pbi report which is 202409 version.

    It works fine in the power bi desktop, but not working after deploying to PBIRS.

 

    There is a table visual in my page and a column describing ranking.

    I set the Data limit to 200 and it only shows 200 records in PBI Desktop.

    But when i deploy to PBIRS, the Data limit does not work and the filter pane still shows Data limit to 200.

 

    does anyone have any idea?

Data Limit
Power BI Report Server
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Vanchy_Liao 

     

    Thanks for the reply from d_gosbell .

     

    I have a workaround for your reference.

     

    I wrote an Index column in DAX, sorted by Sales from smallest to largest.

    Index = RANKX(financials, [ Sales], , ASC, Dense)

     

    Then use that column to filter the table visualization.

     

    Output in PBIRS web portal:

     

    It's also possible not to put the Index column in the visualization, just to filter the effect is the same, I put it in to show the effect more obviously.

     

    I used the Calculated column for the above test and measure for the following.

    SUM = SUM(financials[ Sales])

     

    IndexM = RANKX(ALL(financials), [SUM], , ASC, Dense)

     

    Output in PBIRS web portal:

     

    You can also add the index column to the Transform data.

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    1 year ago

    Sounds like it might be a bug. I'd suggested raising a support ticket with Microsoft to get this investigated.

  • yioann's avatar
    yioann
    Frequent Visitor
    1 year ago

    I confirm the bug, Power BI RS Version1.21.9032.4573(September 2024).

     

    So, September release introduced two new features, and one of them doesn't work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Vanchy_Liao 

     

    Thanks for the reply from d_gosbell .

     

    I have a workaround for your reference.

     

    I wrote an Index column in DAX, sorted by Sales from smallest to largest.

    Index = RANKX(financials, [ Sales], , ASC, Dense)

     

    Then use that column to filter the table visualization.

     

    Output in PBIRS web portal:

     

    It's also possible not to put the Index column in the visualization, just to filter the effect is the same, I put it in to show the effect more obviously.

     

    I used the Calculated column for the above test and measure for the following.

    SUM = SUM(financials[ Sales])

     

    IndexM = RANKX(ALL(financials), [SUM], , ASC, Dense)

     

    Output in PBIRS web portal:

     

    You can also add the index column to the Transform data.

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Vanchy_Liao's avatar
      Vanchy_Liao
      Icon for Advocate IV rankAdvocate IV
      1 year ago

      Hi Anonymous ,

      i hope MS can fix this issue and thanks your solution.