Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

Power BI report with integrated Power App using OneDrive - not enough lines

Hi all,

I recently discovered the whole Power Apps thing and I need some advice, please.

Goal: enable users to change a Power BI report (a table within a page) directly in the said report. Then, after the refresh, the report will display the new values AND update the measures.

E.g. a report line will include 'Invoice ID' and 'Invoice Value'. The user will update the 'Invoice Value' from, say, 500 to 700, and the new total displayed will be 700.

What I have: a 365 license. This means I can create an app and use a OneDrive table,

Problem: it can only include 1,000 lines, and I need at least 60,000.

What I tried: I thought about creating tables in the Dataverse, but this license does not allow it, and I can't get admin rights for the entire company database.

Then I thought about creating a new testing environment to share with these users (like 20 people),

New problem: that's also not included with my license.

Question: if I get a better license (per user? what's the name?) can I create this environment and share the app within with these 20 people who still have 365 licenses? This is the only solution I came up with... Of course, if you guys have another one, I'm all ears.

Thanks in advance,



Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.