Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
BourbonCoffee
Frequent Visitor

Insert Power BI dataset into SQL Server using XLMA Endpoint

‎10-11-2023 10:00 AM

Hi!

 

Any of you know if it is possible to insert data from a Power BI dataset into a SQL Server table? I'm trying through XLMA Endpoint but so far I can only refresh and do some queries using DAX from SSMS.

 

We need create a daily record from a dataset generated from a Power BI report. I appreciate your help.

 

Thanks!

Labels:
Message 1 of 2
566 Views
0
1 ACCEPTED SOLUTION
edhans
Super User
Super User

‎10-11-2023 10:22 AM

Right now, the best way to do this is using Power Automate to query the dataset, return a recordset, then append to a SQL Table. Asking in the Power Automate forum for the steps would be best.

With the release of Fabric there will be I believe better ways to do this, but it is all in preview now and not fully functional.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

Message 2 of 2
554 Views
0
1 REPLY 1
edhans
Super User
Super User

‎10-11-2023 10:22 AM

Right now, the best way to do this is using Power Automate to query the dataset, return a recordset, then append to a SQL Table. Asking in the Power Automate forum for the steps would be best.

With the release of Fabric there will be I believe better ways to do this, but it is all in preview now and not fully functional.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Message 2 of 2
555 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All