Dynamic Management View (DMV) queries against PowerBI model. How to automate load into DB?

Hi  I have been using SQL Server Management Studio to manually execute DMVs to query XMLA endpoints in our PowerBI Premium workspaces. These queries return useful information on the underlying PBI S...