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

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Power BI Dev Camp Session 32

Ted's Dev Camp - March 30, 2023

In this session, we'll examine important design issues and decisions that arise when developing with Power BI embedding.

Top Kudoed Authors