Forum Discussion

JUNPEI's avatar
JUNPEI
Frequent Visitor
2 years ago
Solved

Can we write data to on premise database?

I have set up the on-premise data gateway. I have no issue ingesting data from on-premise database (e.g. Oracle, MySQL, MS SQL) to the LakeHouse. My questions is, is it possible to write data back to...
Dataflow
  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    2 years ago

    Hi,

     

    As per my knowledge only 2 options you have -

    1.PowerOn integration 

    2.powerapps integration 

     

    Both requires additional spending.

lbendlin's avatar
lbendlin
Super User
2 years ago

Anonymous you missed the point of the question.  It is about the ability to write into on-premise data source from Power BI/Fabric.

 

That is not officially supported in Power BI. There are workarounds, none of them reliable.

 

It is however, standard practice in Power Automate and Power Apps - using the same On-premises gateways.

SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
2 years ago

Hi,

 

I have seen applications in production which uses PowerOn visuals for doing write-back.But every one can't afford it as it is little expensive and your workspace should be on premium capacity and XMLA read/write enabled.And poweron team will provide training on how to create those visuals.

 

Thanks,

Sai Teja