Multiple Relationships on Direct Query Feed

[JohnnyT48]

Having issues on a Direct Query Managing Relationships.

I can create a Calendar Table to manage the date connection ok. 

Then I need to link 2 more 

1. Project Number

2. Client Number

I can only make an active relationship between 1 link.... 

What is the best way to create a link while in Direct Query Feed, please not I cannot publish the file on Service if I create a table from the direct query. Need the soltuion within Direct Query.

Screenshot below:

[Anonymous · Accepted solution]

Hi @JohnnyT48 ,

Relationships based on multiple columns should be avoided in the table model, even in DirectQuery. Relationships based on a single native column always generate better query plans in DirectQuery. When native columns are not available, you should use COMBINEVALUES to create calculated columns in both tables to define the relationship between them. More details can be found at the link: Using COMBINEVALUES to optimize DirectQuery performance - SQLBI.

More detailed information about the direct query model can be found in the documentation:
DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn
DirectQuery in Power BI - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.