PowerApps PowerBI Integration record limit 1000

[hnguy71]

Good afternoon, everyone!

I'm utilizing PowerApps Integration with PowerBI Pro service and I'm only able to retrieve a maximum of 1000 records, or it's only showing me up to 1000. I know the integration is more geared towards mobile but is it possible to obtain all the records? Could I do a ForAll loop and grab them into a collection?

[cblanton]

@hnguy71 Do you have a link to documentation that defines this 1000 record limit - or by now, hopefully, a higher limit? 🙂

[hnguy71]

Hey @cblanton, here's the documentation on it:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual#limitations-of-...

Unfortunately, there's still that 1000 limitation. However, there are newer methods to obtaining relevant data into PowerApps that bypasses this limitation.

One particular methodology is this:

1. Send a PowerBI REST API call to execute a DAX query.

2. Result will be in JSON with a maximum of 100k rows, however, this could be looped indefinitely to get you the amount of values you need/want.

3. Store the results in a collection and you're good to go!

[bulprosbibg]

Do you have any solution? Im struggling the same thing and I dont know how to do it:(

[GilbertQ]

Hi there

I think that it is a current limitation.

I would suggest rather adding in filters to get the data you require?

Or to use Power BI to display all the records?