PowerBIIntegration record limit 1000?

[hnguy71]

Good afternoon, everyone!

I didn't realize that PowerBI Integration has a limit of 1000 records, or it's only showing me up to 1000.

EDIT: Seems like my gallery can view all my records imported from PowerBI but my collection still states that I only have 1000 records in them. Can someone explain?

[v-yutliu-msft]

Hi @hnguy71 ,

Could you show me your formula about creating collection?

Under normal circumstances, the collction has a limit of 2000 records.

So please check whether you have delegation warning and the setting of your non-delegable limit.

I guess that maybe you set the non-delegable limit to 1000 and using non-delegable functions.

If so, I recommend you:

1)Modify the formula appropriately

Here's a doc for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

2)change the non-delegable limit to 2000

You could change it here:  File->Advanced settings->non-delegable limit

3) save the recond to collections by every 2000 records

Collect(ds1,datasource); //Collects the first 2000 items

Collect(ds2,FirstN(Sort(datasource,Descending),100)); //Collects the rest of the items

Here's a similar issue for your reference:

https://powerusers.microsoft.com/t5/General-Discussion/ClearCollect-for-more-than-2000-records/td-p/...

Best regards,

Community Support Team _ Phoebe Liu

[hnguy71]

Hi @v-yutliu-msft ,

I can share my setup with you. Here I've pre-set the delegation to it's maximum limit of 2000.

Following that, I create a method to generate a table that shows the amount of iterations required to collect all my records:

My method above works flawlessly for SharePoint records and I'm trying to replicate it to PowerBI. From the image below, you can see it takes three iterations to retrieve all my records:

And finally, I'm doing a check by creating a label to count the number of rows currently in my collection:

My gallery sucessfully shows all my records, however, my collection count only shows 1000.

[v-yutliu-msft]

Hi @hnguy71 ,

There are some Limitations of the PowerApps custom visual for powerBi

Please check whether these limitations affect your formula:

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

Best regards,

Community Support Team _ Phoebe Liu

[hnguy71]

Hi @v-yutliu-msft , @RandyHayes , @v-xida-msft 

Maybe someone can help me with this issue. I took a vacation and just returned to find out that my current app project is broken. Did PowerApps / PowerBI Integration change recently? I have a button that patches two galleries to two SharePoint lists using an OnSelect property:

ForAll(g_HighLevel.AllItems, Patch(Level1_BSN, Defaults(Level1_BSN), {GM: GM, PL: PL, Module: Module, SL_Balance: SL, TB_Balance: TB, Difference: Difference, ERP: ERP, Year_Quarter: 'Quarter-Year'}));

ForAll(g_Detail.AllItems, Patch(Level2_BSN, Defaults(Level2_BSN), {GM: GM, PL: PL, Module: Module, SL_Balance: SL, TB_Balance: TB, Difference: Difference, ERP: ERP, Year_Quarter: 'Quarter-Year'}))

I'm experiencing two issues:

1. List 1 populates all entries, however, only the first 5-28 entries are successfully created while the rest are just blanks. (image below)
2. List 2 does not get triggered to record entries to SharePoint.



Side note: On my first and 3rd post, I was able to retrieve all records through different iterations even though it's not visually there. However, I noticed that now I'm only to retrieve a maximum of 1000 records.

Any help would be greatly appreciated!

EDIT: RIGHT AFTER I POSTED POWERAPPS DECIDED TO WORK PROPERLY AGAIN.... I'M ABLE TO PULL IN ALL MY INFO NOW.

[v-yutliu-msft]

Hi @hnguy71 ,

I'm afraid there's no Official document about PowerBIIntegration record limit.

There has been some problems about dynamically getting value in one specific version PowerApps.

Try the latest version of PowerApps and recreate the app.

Best regards,

Community Support Team _ Phoebe Liu

[RandyHayes · Accepted solution]

@hnguy71 

Sounds like you got it working from your last statement.  

Yes, there WAS a big problem yesterday with the latest version of PowerApps in regard to Gallery Items.  

Hopefully this is fixed now....and hopefully will not return in another release.

[NMCLEOD]

After some help from @Audrie-MSFT I raised a ticket with Microsoft back in January on this very subject.  After spending some time with the tech guys proving that I wasn't mad they confirmed the 1000 record limit, and I got it in writing:

[hnguy71]

Yep. Sad news. I really think they should raise it up to 5000.

In a better note though, if you're exporting that data elsewhere it's possible to create iterations and have all your data displayed elsewhere.

[bulprosbibg]

Hello hnguy71, 

Have you succeed to collect more than 5k rows of data? Im having the same issue now, Im using Gallery.AllItems but they are only 1,000 rows because of PowerBI Integration Limitation. Im using the following:

ForAll(Gallery1.AllItems,
FCST_Automation_CustByProj.Run(DataLevelCode,
AdjustmentLevelCode, LegalEntityCode, LegalEntityCurrency,
FiscalYear, Period, TransactionCurrency, VALUE,Dim_GLAccount, Dim_CostCenter,
Dim_LegalEntityPartner, Dim_TransactionType, PostingDescription))

But the results are only 1,000 rows. I need to collect at least 5k. I will appreciate you help If you can give me some advice.

Thanks.