Unanswered

Loading more than 2000 rows using PowerBIIntegration.Data

(0) Share

Report

Posted on by cmndflom

I have seen that it is possible to load more than 2000 records into your PowerApp using SQL server and SharePoint; I have tried to replicate this same logic to bring in data from PowerBIIntegration.Data but I have not been successful in doing so.

I am trying to split my data up into collections (a total of about 10,000 records) and then call on this collection to be displayed in a gallery.

The unique identifier in my data is a combination of ID and row_id. This is the code I currently have written:

ClearCollect(colAllData, Filter(PowerBIIntegration.Data, ID <= 2000), Filter(PowerBIIntegration.Data, ID <= 4000 And ID >= 2001), Filter(PowerBIIntegration.Data, ID <= 6000 And ID >= 4001), Filter(PowerBIIntegration.Data, ID <= 8000 And ID >= 6001), Filter(PowerBIIntegration.Data, ID <= 10000 And ID >= 8001), Filter(PowerBIIntegration.Data, ID <= 12000 And ID >= 10001));

I have tried using "ID && row_id <= 2000" but this did not work either. Any help or suggestions would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cmndflom ,

Would a user scroll through all the X records?

Ideally use filters.

Check https://youtu.be/NTUfX9HNdK0

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No
cmndflom 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, the ideal scenario would be that the user can scroll through all records. I do have a search bar above my gallery to help filter down results. Is it still possible to bring in that many records into a collection when you use PowerBIIntegration.Data?

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@cmndflom ,

You can collect all the records in a list if you have a unique numeric identifier other than the ID - I have a blog section that explains the process.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No