Push PowerBI data - table - to a WebApp - searching for a solution

[Anonymous]

Hello, I have a PowerBI file with connections to an Oracle database. I would like to export some of that data to a Web App my colleagues have built. The backend of the App uses a MySQL database.

I tried exporting tables from PowerBI to MySQL using DaxStudio (SQL exporting services) without success. 

I also looked into APIs, but all it provided were dataset metrics and not actual table contents. 

My question is, have you been able to update MySQL tables automatically through PowerBI?

[Anonymous · Accepted solution]

Hi @Anonymous,

AFAIK, current power bi report does not include writeback features. Perhaps you can integrate power bi with power apps or power bi automation to achieve writeback operations.

Write-back into SQL Database using Power BI with Power Apps - Visual BI Solutions

Advanced | Flow of The Week: Advanced Approval Write back | Power Automate-blogg (microsoft.com)

Regards,

Xiaoxin Sheng