Import data from another Power BI dataset

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:

Power BI Service Live Connection 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?

Power BI - Server Settings

And guess what:

Get Data

Bonus points if you know how to write your DAX:

Get Data with DAX

Have fun!!

 Share!

 
comments powered by Disqus