While I was working with a client they were trying to import data from another Power BI dataset to their file and they got this error:
This got me thinking that when we try to connect to a running Analysis Services it asks us if we want to import ou connect live. We also know that Power BI is an Analysis Services. Could the server connection string helps us here?
And guess what:
Bonus points if you know how to write your DAX: