Composite Model

[Anonymous]

I want to create a composite model on top of a dataset that is a direct query on an Azure SQL DB.  I can open the dataset in Desktop (it is published to my own worksapce) but when I go to 'Get Data' the options to add other datasets are greyed out?  Is this feature only enabled for PRO licenses? or is it not possible on Azure SQL DB direct query source?

[amitchandak · Accepted solution]

@Anonymous , Please refer to this limitation "Using DirectQuery on datasets from “My workspace” is not supported. This will be resolved shortly after public preview."

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/

[Anonymous]

Thanks for the super fast answer - I'll try publishing to a corporate workspace so I can test this out.