Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Kudoed Authors