Felss DWH Writeback Table

No more one-way data !

Change the game and unlock the value of your Power BI reports. Here is an offer to add your solution a professional level advanced feature !

Felss DWH Writeback Table empowers users with the capability of editing and saving the data back to a database within the Power BI plattform using an intuitive datatable.

This visual is especially useful for budgeting process where it is desired to make forecasts using an existing reports. Other use cases could be for recording comments or notes about invoices or payments. Even project management or masterdata management could be streamlined using this flexible datatable visual. It seamlessly embeds into the Power BI environment and existing reports without the need to switch to an another system for data maintenance. This ensures that the users work always with actual data improving efficiency and data quality.

Build a a self-service platform

Manual changes are saved at backend using a REST API. This visual can be used to display existing data from the existing Power BI model with selected columns to be editable, so that the user either can update the existing data or add a new record to the existing dataset. Following the save command all changes (including the new lines) are sent using the standard fetch api to the selected web service. The field names that the web api expects can be customized and must not necessarily be the display name on the report.

This visual supports :

• the BI Developers to collect information from the users without the need for a custom developed application.
• the users to provide information without leaving the accustomed report page.

Important features :

• Insert/delete row
• Edit data in form of numbers, text, textarea with multiple rows, date or checkbox
• Automatic saving to prevent data loss
• Automatic refresh after saving ensuring an unified experience
• Lock columns
• Show/hide columns
• Native Power BI design. Use any existing Power BI model