01-05-2018 01:10 AM - edited 01-05-2018 04:07 AM
I'm developing Power BI dashboard which shows some anomalies in database to the user. He then should decide what to do: correct data with new value (manual input), or flag it for future offline analysis (manual selection of flag) - so I need in SQL INSERT statement run on Azure database. As far as I understood so far, Power BI doesn't provide any functionality for writing data into database? So there are no options to interact somehow? If I use URL in a table structure, I still can't enter required values manually and can't forward these values to database. Even if I add standard HTML visual, it doesn't allow processing of link clicks or button pressing.
What would be suggestions from experts?
01-07-2018 09:41 PM
As Power BI is a Business Intelligence tool for users to fetch and analyze underlying data, there is no build-in options to edit or insert data records in database. However, here is a similar thread in which some workarounds are mentioned. Could you go to check if it help in your scenario?
01-08-2018 01:10 AM
Thank you to pointing to the thread.
However, I already noticed that MS announced PowerApps tool: https://powerapps.microsoft.com/en-us/blog/powerbi-powerapps-visual/ what is intended to do exactly what's required. No any documentation so far, and any clue how to tune it, but anyway it looks like it exists.