Data limit feature is not working after deploying to PBIRS

[Vanchy_Liao]

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?

[yioann]

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 · Accepted solution]

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]

Hi @Anonymous ,

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

[d_gosbell]

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