Import data from another Power BI dataset








⚠ WARNING: The content of this post has been made deprecated due to the availability of composite models and you should use that awesome feature to import the data. ⚠
Check the official announcement on the link below:
https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/
This post is just for future reference







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