Issues with e-plan report

[Anonymous]

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

[Anonymous]

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