PowerBIIntegration record limit, work around?

[travisk]

Hello,

I have a PowerApp with a collection of data in it that I would like to join/filter a part description column from a PowerBI table to.  The issues is that the PowerBI table has about 3 million records/possibilities in it.

I created a collection called Submissions with between 1-100 entries in it.  Then I created a 2nd collection (Submissions2) to add a column to Submissions while filtering my PowerBI data where PartNumber = Submissions(PartNumber).  But after banging my head against a wall for a while I realized there's a 1000 record limit on the PowerBIIntegration.Data table.

Does anyone know of a work around that I could use to link this data?

Collect(
    Submissions2,
    AddColumns(
        Submissions,
        "Part Description",
        Filter(
            PowerBIIntegration.Data,
            PartNumber = Submissions[@'Part Number'],
            PartDescription
        )
    )
)

[hnguy71]

3 million records are a lot.  There's a hard limitation of 1000 as you encountered. Does your PowerApps require PowerBI as a data source?

[v-xida-msft · Accepted solution]

Hi @travisk ,

Just as you mentioned, currently, there is a limit within the PowerBIIntegration.Data table within PowerApps. The PowerBIIntegration.Data table could only retrieve 1000 records at most within a canvas app.

If you want to link 3 million records with your Submissions within a canvas app, I afraid that there is no way to achieve your needs in PowerApps currently.

If you would like this feature to be improved in PowerApps, please consider vote the following idea:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Increase-PowerBIIntegration-Data-record-limit-fr...

Best regards,