| ⚠ 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:
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:
Have fun!!