Forum Discussion

anselmojg's avatar
anselmojg
Advocate II
6 years ago
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...
Need Help
  • JirkaZ's avatar
    JirkaZ
    6 years ago

    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.

anselmojg's avatar
anselmojg
Advocate II
6 years ago

Thank you JirkaZ ,

Finally got the chance to test with VS2019 as well and found no way to make a copy over to a SQL Server database...

Will see if the announced read/write XMLA announced for later this year (2020) allows this... I would have thought though that "write" was referring to "write back to Power BI", but maybe you are right and it means "write (Power BI data) elsewhere", which is what we are after...

thanks!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi anselmojg 
Could you please let me know if you were able to copy the data from Power BI datasets to SQL Server database?

I have tried with Power BI Desktop and i was able to load it into SQL tables, however with Power BI Desktop the port keeps of changing so we can't automate that process.
Any guidance would be appreciated!