topic Re: Write Back the data to SQL Database in Developer

Write Back the data to SQL Database

sgmanjunath — Fri, 24 Nov 2023 12:03:26 GMT

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

Re: Write Back the data to SQL Database

tackytechtom — Fri, 24 Nov 2023 12:50:31 GMT

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/

Re: Write Back the data to SQL Database

sgmanjunath — Mon, 27 Nov 2023 05:23:58 GMT

Thanks Tom. Thanks for the information. Let me try these options and update if it worked or not.