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.
Both in SQL and Excel i need to dump this data in a pivot view.
Can some one help me the steps on how can we do these. i went through a lot of videos on write back and i am unable to find a better solution.
Below is the table i have created using summarizedcolumn and then i have added custom columns / measures to this table.
Now, the final table data need to be dum
Regards,
Manju
2 Replies
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 FabricLet 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.
