Forum Discussion
Powerbi can be update the source data or not
I use powerbi to connect SQL database and get data from it , it works fine .
If I want to use powerbi to update the data in SQL database , is it possible ?
Thanks
Hi ckkyoung
Sorry for the late reply. I think it is not a simple Yes or No question. If you want a simple answer, I would reply No. There is no official document to support this possibility. I think this blog explains the question well.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
5 Replies
- Pragati11
Super User
Hi ckkyoung ,
Check the following blog on this: https://bielite.com/blog/write-back-to-sql-database-from-power-bi/
Thanks,
Pragati
thanks reply ,
I have not tried it yet , just would like to confirm if that means powerbi could update the data in source database no matter it is MS SQL , oracle , mysql , excel file etc ?
thanks
v-jingzhangCommunity Support
Hi ckkyoung
It might be possible but it's not suggested to use Power BI to update the data in data source tables. I read the article in that link. It seems not a reliable method to update much data in data sources in batch and may not have a good performance.
Regards,
Community Support Team _ JingThanks reply ,
That means it can update the source data ?
- v-jingzhang
Hi ckkyoung
Sorry for the late reply. I think it is not a simple Yes or No question. If you want a simple answer, I would reply No. There is no official document to support this possibility. I think this blog explains the question well.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
