Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
@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!
Do you have any solution? Im struggling the same thing and I dont know how to do it:(