A standard option to write back data from a Power BI report to a database is by integrating Power Apps with Power BI.
What is Power Apps?
Power Apps is a service that helps users build and use apps that connect to business data.
How does writeback happen using Power BI + Power Apps?
You can embed a Power App within your Power BI report by using the Power Apps visual in Power BI. Your Power BI report passes the data along with context to the Power Apps visual, and the underlying app writes it to a database.
A main benefit of using Power Apps is that it is a native solution offered by Microsoft.
However, using Power Apps for implementing writeback is not for everyone as it has some drawbacks and limitations.
Drawbacks & Limitations of Power Apps (for Power BI Writeback)
- A new skillset: If all you need is to write back data from an occasional report, learning Power Apps may not make sense. Consider the fact that you need to build an application from the scratch, define the screens, controls & workflows so that it can write back data to the database. For an occasional requirement, this is a significant learning curve.
- Separate licensing: You need separate licensing for Power Apps. At the time of publishing this column, it can be $5/user/month for a single app, or $20/user/month for unlimited apps.
- 1000 Row Limitation: At the most, your power BI report can pass 1000 records to the Power Apps visual (using the “PowerBIIntegration” object).
- Filtering: Your Power Apps visual cannot filter data or send any data back to the report.
- Internal use: Power Apps is mainly intended for internal use. There are some restrictions for supporting external / guest users (e.g., channel partners or resellers).
- Report Server: This writeback method does not work in a Power BI report server
- There are other minor limitations too, some of which are listed below
a. You need to share the Apps separately with users in addition to sharing your report
b. There are some change management restrictions – e.g., the app needs to be edited by choosing the ‘Edit’ option in the Power Apps visual and not directly in the Power Apps portal
If I have the skills to develop an app AND can live with all the above limitations, will I be able to build an effective writeback solution?
It depends on the use case. If all you need is a simple update and writeback, you would be able to manage it well. But incorporating any bells and whistles to drive the best user experience would be a challenge.
Let us take sales forecasting as an example. You will still experience gaps in areas such as the following:
- Ability to edit in a tabular interface directly (currently the Data Table control in Power Apps is read only – you need to link it to an editable form that can open up one row at a me)
- Ability to capture forecasts with spreading & allocation methods
- Cell-level commenting
- Option to tag and alert users
- … and more
Overall PowerApps in Power BI is a bit harder than it should be for business users, and yet too restrictive for more advanced scenarios.
This is where running Inforiver on Power BI can make a significant difference.
Inforiver for Power BI Writeback
Inforiver provides out-of-the-box, user-friendly writeback capability to Power BI users using a no-code user experience. You can:
- Perform unstructured writeback (you need not create database tables ahead of time in order to write back. Yes, think about the user experience this can deliver!!) from Power BI
- Write back to databases (such as Azure SQL and Snowflake) & online folders such as OneDrive
- Write back specific measures (instead of writing back all the measures in the report)
- Perform delta vs. full writeback, so that the whole data set need not be written back each time. Only the new rows or changed rows need to be inserted/updated.
- Choose to write back along with (or ignoring) totals & subtotals in a table or a matrix.
- Write back row, cell & data level comments
- Write back filtered data (e.g., data for a specific sales channel in EMEA)
- Allow writeback based on user authorization & permissions
- … and more
Do you want your Power BI report to deliver user-friendly writeback? Try out Inforiver Enterprise today. To learn more, watch our webinar on key writeback options using Microsoft Power BI.
Learn how Inforiver's writeback capability can transform your Power BI reports.