cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
adt180
Regular Visitor

Limit of 1000 Values Reach || Salesforce Reports

So I've run into a conundrum.  Been using Power BI for months in my department and recently generated a new report in Salesfoce that BI in pulling data from.  For some odd reason my 3rd column in is randomly grabbing 1000 of the 5000 available rows instead of all 5000.  Is there a permission set I'm missing?  This is just a plain text field and not set to a particular Data Type

 

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Limit of 1000 Values Reach || Salesforce Reports

@adt180,

This is by design, the manual checkbox selection can only show 1000 values in Query Editor. In your scenario,  you can use “Text Filters” to apply different filters to the result set.

1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
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

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Limit of 1000 Values Reach || Salesforce Reports

@adt180,

This is by design, the manual checkbox selection can only show 1000 values in Query Editor. In your scenario,  you can use “Text Filters” to apply different filters to the result set.

1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
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

pablobarra Advocate I
Advocate I

Re: Limit of 1000 Values Reach || Salesforce Reports

Hi

 

Power BI conection to Salesforce reports has a limit of 2000 records, you won't be able to get more than that till this is changed in Salesforce side.

 

I saw that you want to select a field name, there is a limit in Power BI of 1000 values in the manual checkbox. You will receive 2000 records, but the manuakl selection will show only 1000 in query editor.

 

If you want to pick a single value, you can use the filter option (equals= fieldname).

 

If you want to get the latest one, you can use the SFDC Createddate field and apply a filter (last 30 days or so) before filtering by name.

 

You can also remove "SRQ-" in you example from SRQ request, and change type to numeric (the name field is autonumeric plus "SRQ-"). You can sort descending and that will allow you to select one of the laatest 1000 records.

Or you can add a filter like the numeric value is greater than....

 

Regards

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors