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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.