Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

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











Super User
Super User

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:


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 🙂



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn


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

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors