Forum Discussion
Solved
Copy Power BI dataset tables to SQL Server (using XMLA endpoint connectivity)
Hello, We have a Power BI dataset/reports in the Service refreshed daily with the latest Supply Chain plan from SAP. This is working great. But we have the need to take “snapshots” at regular inter...
To my knowledge it's not possible yet (tried VS2019 too). The support for SQL Server Data Tools should come with the introduction of read/write XMLA endpoints.
hi Anonymous
I ended up taking a completely different path using Paginated Reports connected to the Power BI dataset containing the data we want to "copy"... With Power Automate, we schedule an expòrt action using the Paginated Report and save the file (excel or csv) in a SharePoint library.. It works well enough....