Insert Power BI dataset into SQL Server using XLMA Endpoint

[BourbonCoffee]

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!

[edhans · Accepted solution]

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.