topic Data limit feature is not working after deploying to PBIRS in Report Server

Data limit feature is not working after deploying to PBIRS

Vanchy_Liao — Fri, 08 Nov 2024 05:19:57 GMT

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?

Re: Data limit feature is not working after deploying to PBIRS

d_gosbell — Mon, 11 Nov 2024 02:00:26 GMT

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

Re: Data limit feature is not working after deploying to PBIRS

Anonymous — Mon, 11 Nov 2024 06:52:36 GMT

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.

Re: Data limit feature is not working after deploying to PBIRS

Vanchy_Liao — Mon, 11 Nov 2024 09:52:48 GMT

Hi Anonymous ,

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

Re: Data limit feature is not working after deploying to PBIRS

yioann — Wed, 20 Nov 2024 09:01:27 GMT

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.