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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
sgmanjunath
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

 

 

snapshot.PNG

 

 

 

 

 

Regards,

Manju

2 REPLIES 2
tackytechtom
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:

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/



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

#proudtobeasuperuser 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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