I am having 20k dataset in powerbi which i am trying to integrate into power app ,but as the data limit in power bi is 2k ,it's not showing all the records.
steps i have done till now :
i have published the report to powerbi web version
from there i am fetching the data to powerapp .
but not all the records are showing up .Kindly suggest some idea to integrate all the records.
For datasets larger than 2,000 records, storing data in a backend like Dataverse, SQL Server, or SharePoint and integrating Power Apps with it is the most efficient approach.
Fetch data in chunks using Power BI REST API and paginate the results in your Power App.
nable the Power BI REST API in your environment.
Write a custom Power Automate flow or use a custom connector in Power Apps to:
Query data in batches (e.g., 2,000 records at a time).
Aggregate and store the fetched data in a collection or intermediate storage like Dataverse or SharePoint.
Display the aggregated data in Power Apps.
pls try - thanks
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.