Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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:
Best Regards
Lucien
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:
Best Regards
Lucien
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:
Best Regards
Lucien
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.