Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Issues with e-plan report

Submitted by Anonymous on ‎02-13-2023 08:02 AM

issue information

 

Join paths are expected to form a tree, but the table 'vwFuelTransactions' has two join paths to table 'Client report levels': 'vwFuelTransactions'->'Client report levels' and 'vwFuelTransactions'->'FuelTransactionDate'->'Report date'->'Fact executive summary'->'Client report levels'. Technical Details: RootActivityId: 3477aa81-2d17-4b9e-96a5-5145a0f84142 Date (UTC): 2/13/2023 3:53:15 PM

 

Activity ID: 05d24874-5497-4ea0-bf71-70c5f0fb25ed
Request ID: 592056cf-eea3-bfd1-fd5d-672ea04b8ce7
Correlation ID: ecdbe5b3-6121-0aee-cce2-4be39f9c2f46
Time: Mon Feb 13 2023 09:55:23 GMT-0600 (Central Standard Time)
Service version: 13.0.20053.53
Client version: 2302.1.12237-train
Cluster URI: https://WABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 05d24874-5497-4ea0-bf71-70c5f0fb25ed
Request ID: 592056cf-eea3-bfd1-fd5d-672ea04b8ce7
Time: Mon Feb 13 2023 09:55:23 GMT-0600 (Central Standard Time)
Service version: 13.0.20053.53
Client version: 2302.1.12237-train
Cluster URI: https://WABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net

 

 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎02-14-2023 01:41 AM

Hi @Anonymous ,

 

The error that you are getting indicates that you have two active relationship paths between two of your tables, so Power BI doesn't know which one to use. The general fix to that is that you have to adjust your filter flow (single or both) or otherwise change your model so that you do not have two paths between tables. 

 

Best regards.
Community Support Team_ Caitlyn

Idea Statuses