Forum Discussion
Write back to database using Power BI report
Hi Mystery,
AFAIK, power bi desktop does not include any writeback features. It is a reporting tool that is used to get data from specific data sources and design charts and visualizations.
If you want to do writeback operations, you may need to use external tools or integrated external features. (e.g. powerapps, r script, python)
Using Python in Power BI Power Query Editor - Power BI | Microsoft Docs
Use R in Power Query Editor - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
Hey!
Inforiver, a custom visual for Power BI, would fit your requirements.
To be specific, some of the use cases for which Inforiver can be used are:
Distributed Sales Data Entry & Writeback in Power BI Reading View: Captured distributed data entry (say, from 500 sales reps) in Power BI Reading (read-only) mode and write them back to a central location along with user rep name and time stamp
Bi-Directional Writeback: Writeback data to a database or file destination and retrieve (updated) data from the data store with direct query live consumption with other Power BI visuals and reports
For more details, sign up for our webinar coming up on April 5, 2022. You can also watch a replay of the webinar in case you are not able to make it.