I can't find Composite Models

[FreddieTheCat]

When I try to run a direct query and/or edit one.

I see this message:

'this query contains transformations that can't be used for directquery'

I am reading online and it says that the solotion is to deactivate Composite Models.

I do not see Composite Models as an option. Please take a look at my screeen shot.

What should i do?

[v-juanli-msft]

Hi 

Is this problem sloved?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shyamji]

Hi,

if this is inbuilt feature in latest version then why i am unable to create many:many relationship?

Thanks

Shyamji

[v-juanli-msft]

Hi @FreddieTheCat 

First check your version of Power BI Desktop, if it is old, please update to the lastest one.

https://docs.microsoft.com/en-us/power-bi/desktop-latest-update

Then it is import to know that:

using direct query you can not create conditional columns in query editor but instead you can create a new column and write your condition there. 

If this is not your pronlem, please click each steps on the "applied steps" pane to check which step leads this problem.

Here is a similar thread which has solutions:

https://community.powerbi.com/t5/Desktop/Direct-Query-Transformation-error/td-p/363775

Also, please check the limitations in the data transformations that can be applied within Query Editor with direct query

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @FreddieTheCat 

Do you use the lastest version?

Composite Models is supported in Power BI currently.

It is no longer a preview feature. It doesn't need to turn on any option to use it.

https://docs.microsoft.com/en-us/power-bi/desktop-composite-models

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.