Hi, I'm sorry for the delayed response. You are correct that the Power BI Publisher Add-in will allow you to connect to the Power BI DataSet but as a connection only. I am looking to move the data from the Power BI Dataset into the Excel DataModel in one step.

My attempts to do this through Power Query M using the https://msdn.microsoft.com/en-us/query-bi/m/analysisservices-databases have not worked.

I do not know if this is because I'm unable to connect or I have bad syntax. However, I would rather not use this option and would like a simpler way than having to write Power Query M.

There are many ways to "Import" from Analysis Services - (I'm using the term import in a reserved way here, as described in https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery)

"Import – the selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data. You must refresh the data, which imports the full data set again, to see any changes that occurred to the underlying data since the initial import or the most recent refresh"