The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
Solved! Go to 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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |