Write Back To MySQL Database connected with ODBC

[fraame]

Is it possible to make an "INSERT INTO..." query to a MySQL Database connected with PowerBI througth ODBC?

I want to add the data contained into a table in a PowerBI report to a table of my database.

Thank you in advance.

[v-luwang-msft · Accepted solution]

Hi @fraame ，

The write-back function in Power Apps is available to accommodate this. Write-back enables end users to change and update the values in the data warehouse directly from the Power BI report. 

The following article describes in detail how to Write-back into SQL Database using Power BI with Power Apps：

https://visualbi.com/blogs/microsoft/powerbi/write-back-into-sql-database-using-power-bi-with-power-... 

Best Regards

Lucien

[v-luwang-msft]

Hi @fraame ,

An example of SQL write back with PQ:

let
  Source   = Sql.Database("myserver", "newtest"), 
  emailVal = "2@xyz.com", 
  Custom1  = "INSERT INTO [newtest].[dbo].[Table_1] (Email) VALUES('" & emailVal & "')", 
  Custom2  = Value.NativeQuery(Source, Custom1)
in
  Custom2

 Something like this

let
Source = Sql.Database("myserver", "newtest"),
SSAS query = SSAS Q with DAX query,
Val = convert the SSAS query to SQL insert row,
Custom1 = "INSERT INTO [newtest].[dbo].[Table_1] (Email) VALUES('" & Val & "')", Custom2 = Value.NativeQuery(Source, Custom1)
in Custom2

To learn more details ,refer:

https://community.powerbi.com/t5/Desktop/Writing-Calculated-Visualization-Back-to-SQL-Table/m-p/2245... 

Best Regards

Lucien

[lbendlin]

Word of warning on the Power Query approach - there is a very real chance that these queries will triggered multiple times, or not at all.

[lbendlin]

The general answer at the moment is no - Power BI does not support robust write-backs. You can cheat by using R or Python visuals, but these require the use of a personal gateway.

If this is important to you please consider raising it at https://ideas.powerbi.com