Forum Discussion
PowerApps PowerBI Integration record limit 1000
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 inte...
hnguy71 Do you have a link to documentation that defines this 1000 record limit - or by now, hopefully, a higher limit? 🙂
Hey cblanton, here's the documentation on it:
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!
