Forum Discussion
Write Back the data to SQL Database
Hi Team, I have created a new table PBI using Summaraized columns and then added customer columns along with few measures. Now, i want to write back this table data to SQL table and Excel. B...
Hi sgmanjunath ,
Depending on how much data you have, you can use the ExecuteQueries API with which you can fetch the data from a dataset / semantic model based on a DAX query. The result you could then process further or directly push into a database. Here, a way of doing this with Azure Data Factory:
https://www.tackytech.blog/how-to-query-and-copy-data-from-power-bi-datasets-via-azure-data-factory/
In fact, in Fabric this kind of stuff will be easier as there is a button to "writeback" the data from an import mode model diretly into direct lake:
Microsoft Fabric November 2023 update | Microsoft Fabric Blog | Microsoft Fabric
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Thanks Tom. Thanks for the information. Let me try these options and update if it worked or not.