Hi,
I've been strugging with building a relationship between my tables. Everything in the Create Relationship window is not available (cannot select another table).
The data source is a DirectQuery to AS - PowerBI Dataset. I've tried changing the storage mode but this seems to be disabled.
I need a one-to-one relationship between the tables so that my filters affect all the visuals I've made.
Also, I can't make any changes to the table as the Query Editor also seems disabled.
Grateful if someone can help me with this.
Comments
- robyfauvess on: Measures don't translate
-
v-tianyich-msft
on:
Major bug in ENDOFMONTH function
-
v-yetao1-msft
on:
BUG New card visual display units doesnt work in s...
-
v-xiaoyan-msft
on:
Published Power BI app reverts to an old version f...
-
naelske_cronos
on:
SharePoint data source - authentication method ser...
-
v-tianyich-msft
on:
Wrong Calculation in Table for New calculated Colu...
-
v-xiaoyan-msft
on:
Incorrect icon per value on the matrix visual
-
v-yetao1-msft
on:
Failed to save modifications to the server. The en...
-
v-yetao1-msft
on:
Issue trying to deal with load huge excel DB (abou...
- Jalshaikh on: Problem signing in to my account
Hi @sarah99 ,
It's a limitation for now. Use composite models in Power BI Desktop - Power BI | Microsoft Learn
If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Community Support Team _ Caitlyn