Reply
Frequent Visitor
Posts: 3
Registered: ‎01-05-2018

Interactions with Database - how to?

[ Edited ]

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?

Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

Re: Interactions with Database - how to?

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? Smiley Happy

 

Regards

Highlighted
Frequent Visitor
Posts: 3
Registered: ‎01-05-2018

Re: Interactions with Database - how to?

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.