topic Interactions with Database - how to? in Developer

Interactions with Database - how to?

Alexei — Fri, 05 Jan 2018 12:07:51 GMT

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?

Re: Interactions with Database - how to?

v-ljerr-msft — Mon, 08 Jan 2018 05:41:18 GMT

Hi @Alexei,

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?

Regards

Re: Interactions with Database - how to?

Alexei — Mon, 08 Jan 2018 09:10:49 GMT

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.