Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Vanchy_Liao
Resolver I
Resolver I

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?

1 ACCEPTED SOLUTION
v-xuxinyi-msft
Community Support
Community Support

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.

vxuxinyimsft_3-1731307029352.png

 

Output in PBIRS web portal:

vxuxinyimsft_4-1731307098102.png

 

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.

vxuxinyimsft_7-1731307868519.png

 

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:

vxuxinyimsft_5-1731307456174.png

 

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

vxuxinyimsft_6-1731307586702.png

 

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.

View solution in original post

4 REPLIES 4
yioann
Frequent Visitor

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.

v-xuxinyi-msft
Community Support
Community Support

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.

vxuxinyimsft_3-1731307029352.png

 

Output in PBIRS web portal:

vxuxinyimsft_4-1731307098102.png

 

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.

vxuxinyimsft_7-1731307868519.png

 

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:

vxuxinyimsft_5-1731307456174.png

 

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

vxuxinyimsft_6-1731307586702.png

 

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.

Hi @v-xuxinyi-msft ,

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

d_gosbell
Super User
Super User

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.