I have done a blog post on SQL DWH and hooking it to Power BI then playing around with queries around sys.dm_pdw_nodes etc etc. do you want a link to it?