Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

10 Key Considerations for Choosing a Writeback Solution in Power BI

by Inforiver | Jul 12, 2022 |

You have probably explored using Microsoft Power Apps for data writeback from a Power BI report. In one of our previous posts, we learnt how this approach is a bit harder than it should be for business users, and yet more restrictive for advanced use cases.

Since BI platforms & tools are optimized for reading large volumes of data – there is no integrated native solution that offers writing back data to SQL database destinations.  Given this, you may also have explored custom solutions or third-party visuals for Power BI that provide write-back capabilities.

Yet, you mostly wonder which solution offers the right approach, and how to choose one that works best for you. You want the solution to be simpler, deliver value to your users, and stand the test of time by continuing to support your evolving needs.

Here are a few considerations that you need to keep in mind while evaluating a writeback solution in Microsoft Power BI.

  1. Structured vs. Unstructured writeback
  2. Writeback destinations supported (including shared drives)
  3. Support for delta vs. full writeback
  4. Writing back ignoring (or including) totals and subtotals
  5. Write back row, cell, and data-level comments
  6. Write back specific measures vs. all measures
  7. Write back filtered data vs. all the data
  8. Defining writeback authorizations and permissions for users
  9. Time to deploy a writeback solution
  10. User experience
10 Key Considerations for Choosing a Writeback Solution in Power BI

We shall explore each of them in detail.

***

1. Structured vs Unstructured Writeback

A structured writeback is one where you traditionally have the underlying database tables defined by IT and set up in advance so that you can write to it from your Power BI report. Most planning solutions available in the market today for Power BI (and other platforms) follow a structured writeback.

An unstructured writeback is one where you do not need to have the database tables created in advance. The application takes care of it for you. A main benefit is the user-friendliness of this approach, as you can add additional columns or measures even at the last moment. As a result, this cuts down reliance on your IT team and the time-to-realization of value is instantaneous.

Thus, if you have a strictly defined process and you know exactly what you need to get out of your writeback, the structured writeback would work for you. However, such a setup conflicts with the principles of the modern agile process and the end-user-friendly paradigms of the modern BI stack. On the other hand, if you have users who like to move at the speed of thought or have different requirements each day, an unstructured approach naturally works best.


2. Writeback destinations supported

Most solutions support writing back to a SQL server database. Furthermore, ensure that you go beyond this and verify if it supports writing to Snowflake, Azure SQL DB, OneDrive (in Excel), REST API URL destinations, etc.


3. Support for delta vs. full writeback

For instance, let’s say you have a model with a large number of rows in your Power BI report, and you have created the forecast and written back to your database. In the future, if you need to update the forecast for a specific product in a specific region, you can use the delta writeback and avoid writing back all the records.


4. Writeback (or Ignore) Totals & Subtotals

In a table or a matrix report, you will have one or more row or column totals & subtotals. When you write back, it is preferable not to persist subtotal and total records. It is because they are simply aggregation of other existing records. There may be some exceptions where you may want to write back to a database along with these totals. Ensure that your writeback solution in Power BI offers flexibility to write data – with or without totals.


5. Write back row, cell & data level comments

If your table or matrix supports commenting, ensure that you are able to write back comments to your database or a file. It is not of much help for a user to input comments in your report only to realize later that it cannot be persisted outside your report.

While row-level commenting is very common in reporting solutions, cell-level or column-level commenting can elevate your reports to a different level. If your solution supports it, ensure that these can be written back too.


6. Write-back specific measures

Often, we work with several measures while we forecast and simulate outcomes. For example, we may have sales actuals and forecast, quantity shipped and profit margins for the prior periods, and we may be forecasting sales for a future period. In such cases, it helps to write back only the forecast measure for the future period rather than writing back all the measures.

Think about this - If the CRM database containing the actuals gets updated after we do our write-back, our saved data would be out of sync. It’s best to write back only what we create or modify.


7. Write back filtered data

Sometimes, we may be working with a larger data set, but we may be updating only the records belonging to, say, two specific regions. In such cases, you can trigger writeback using a filter, so that records belonging to other regions are ignored. The ability to change this filter criteria on-the-fly becomes important too.


8. Writeback authorization & permissions

Of course, we do not want everyone in the organization to start writing back data from your report. Check if the writeback solution for Power BI provides a way to authenticate and authorize specific users to write back.


9. Faster time-to-deployment

One key consideration you must have while evaluating the writeback solution in Power BI is to get an understanding of how long it would take to deploy the first writeback solution. Another question to explore is the lead time taken for writeback of subsequent reports – as there may be a lot of backend set up and preparation required each time depending on the solution deployed.


10. User Experience

There are writeback solutions that ‘technically’ check the list, but navigating and performing an effective writeback using them is often a struggle. Ensure that the user experience is highly satisfactory. This is one of the most significant factors that guarantees whether your users would keep coming back to the report.

***

Inforiver visual for a seamless & quick writeback Power BI

Inforiver for Microsoft Power BI delivers out-of-the-box and user-friendly writeback capability to Power BI users using a no-code user experience. Key highlights include:

  1. Inforiver can perform unstructured writeback. You need not define the table structures ahead of time. This is a great time saver as it offers a slick, no-code user experience.
  2. Inforiver supports writeback to Databases like Snowflake, Azure SQL, SQL Server, MySQL, Postgres, One-Drive, Share Point, Rest API URL Destinations, and more
  3. With Inforiver, you can choose which measures to write back instead of writing back all the measures in the report. This support is also provided for measures that are calculated or manually keyed in into the report.
  4. Inforiver supports delta and full writeback options
  5. You can choose to ignore totals & subtotals while writing back using Inforiver
  6. All row, cell & data level comments are written back
  7. You can write back filtered dataset (e.g., data for a specific sales channel in EMEA)
  8. You can provide specific permissions & authorizations to users
  9. The no-code experience results in the fastest deployment times in the industry
  10. The hassle-free user experience ensures that users get to their outcomes with the least effort

Go ahead and use the above checklist to compare writeback solution options for Power BI.

To learn more, view our webinar on key writeback options using Microsoft Power BI.


Inforiver Logo
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
ValQBI HubxViz
IBCS Certified
Power BI certified
5920 Windhaven Pkwy, #130
Plano TX 75093
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram