I got this feature running and it is amazing! DAX seems to be changeable, too!
I build some DAX queries in DAX Studio and just pasted them over the one created by the service on export...very slick.
To use this effectively now I would like to read this data into my Data model in Excel. At the moment I am importing the Connected table on the spreadsheet to power query which does not seem elegant...especially for larger Tables!
Is there a way to get those connected tables as Queries in my Excel Power Query directly ??
Thanks and best regards