cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AliceW
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,

Alice

0 REPLIES 0

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.