Forum Discussion
Using Power Apps to append data into Power BI
darentengmfs - this really isn't a Power BI question. Power BI will read data from many sources, as you know.
You are taking it to the next level with using Power Apps to record your data, vs someone doing it in Excel or with another app.
As DataZoe there are ways to add data without Power Apps, like using the default Forms in SharePoint lists.
I love using Power Apps though to do what you want to do, but if you have no experience with it, then I cannot recommend the App in a Day course highly enough! It is free, and here.
Once you get that done, you just create your Power BI report and set the refresh schedule. You can also trigger a refresh from the Power Apps app via Power Automate, but you are limited to 8 refreshes a day with a Power BI Pro license. Power Automate refreshes and Scheduled Refreshes add up. Once you've done 8 refreshes, no more will happen until the next day. If you have Premium capacity, it is 48 per day.If you get bold, then the Direct Query route DataZoe mentioned can be refreshed unlimited times, but this has drawbacks:
- Direct Query requires a real server - SQL Server, Azure SQL, etc.
- You have to have an Enterprise Gateway. Personal will not work with Power Apps/Automate.
- Connecting to such a server requires a Power Apps license that is either $7 per mo for one app, or $40/mo for unlimited apps. SQL Server is a premium connector for Power Apps.
- Direct Query reports in Power BI are much more limited than Import apps. Your transformations are limited, as are some DAX functions and visuals.
Once you get your head around what you want to do and have done the App in A Day course, the Power Apps community can jump in and assist with building the app.
My personal advise - go slow. Use SharePoint Lists as your data source for the app. Don't jump in too deep and get frustrated with gateway configs, proper indexes and whatnot in a SQL Table. Power Apps requirements for SQL Server are higher than Power BI. Both can read any SQL table. But to write, Power Apps needs a unique index field that is hopefully generated by the server on the fly, or you get into creating GUIDs or your own incrementing logic.
Hi edhans ,
Licensing is not my specialty and is no fun, but here is my current level of knowledge.
There are different types of license.
- Power Apps & Power Automate use rights included with Office 365 licenses
- Power Apps & Power Automate use rights included with Dynamics 365 licenses
- Power Apps per App Plan
- Power Apps per User Plan
- Power Automate per User Plan
- Power Automate per Flow Plan
Except for the Office Plan, all should include Common Data Services. But please check that again.
darentengmfs Which license do you use?
I believe that is correct mwegener - which was why I recommended SharePoint LIsts. I fully agree CDS is a better long term solution, especially for projects that will have thousands of records, but it does come with the added expense of $7 to $40 per month per user depending on what other plan is selected.