Forum Discussion
Insert Power BI dataset into SQL Server using XLMA Endpoint
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!
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.
1 Reply
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.