Composite models when connected to AS models (PBI datasets and Azure Analysis Services)

[sander_allert1]

We really love the new feature of 'Composite Models' in the Power BI July 2018 update! This enables us to join custom lists with DirectQuery sources. It would also be beneficial if this would also work when connected to SSAS Tabular in DirectQuery. This would stronlgy improve the enterprise features of Power BI.

[matthewlingard]

When dealing with large data sets this is a huge requirement.

[DavidMoss]

Any progess with the DQSM as whenever i try to enhance the datamodel we are asked to use 'upoad' mode and not DC.

[kzolsen]

I have to import millions and thousands of rows just so I can compute a Year from a date field..... Not ideal

[agreilly]

This is a big limiting factor. I'm really trying to use PBI, but issues like this keep pushing me back to Tableau.

[anthonya]

Direct Query and Import queries must be able to co-exist

[tblackwell2]

From a data governance point of view we can only use DQ to prevent upload of confidential data the the cloud (however secure it may be). We have chosen Power BI for its self service capabilities but this gap renders that redundant. Calculations and modelling will have to be done on the SQL server by Devs, not power users in the business as was our intention. please please add the ability to create power query semantic layer with direct connect!

[fureysmyth]

DIffinately needed....

[adeel_nasir]

If we add a custom column in direct query mode, it says it is not supported in DirectQuery but it is needed.

[proxybon]

Direct query and Import queries must co-exist

[fbcideas_migusr]

This would provide my organisation with massive benefits and could be a positive reason for us to advocate selecting Power BI over another reporting tool like Tableaux. Please provide support for Dashboards and reports using Direct Queries with calculated columns and translations.