Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

What Are These Errors?

Hi,

 

I'm in the process of joining 3 tables by creating a bridge table.

 

I converted the 3 tables to text and append all of them. But upon several attempts to load the data into power bi...I'm getting the first error

 

 

 

 

This second error I managed to get the bridge loaded into power bi. I managed to get one relationhip etablished  and the other one had this error.

 

 

Any idea what are the errors and how to fix them?

 

//NT

Need Help
  • elitesmitpatel's avatar
    elitesmitpatel
    2 years ago

    Hi Anonymous 

    1) 1st one is showing the date related errror, basically error of data type

    2)2nd one "ambiguous path" error  typically occurs when there are multiple relationships between two tables, creating ambiguity in how to navigate between these tables. This ambiguity can confuse Power BI as it won't be able to determine which relationship to use for calculations and filtering.

     

    Accept as Solution if it helps you so other community memebers can easliy navigate.

    Thanks

2 Replies

  • elitesmitpatel's avatar
    elitesmitpatel
    Icon for Solution Supplier rankSolution Supplier
    2 years ago

    Hi Anonymous 

    1) 1st one is showing the date related errror, basically error of data type

    2)2nd one "ambiguous path" error  typically occurs when there are multiple relationships between two tables, creating ambiguity in how to navigate between these tables. This ambiguity can confuse Power BI as it won't be able to determine which relationship to use for calculations and filtering.

     

    Accept as Solution if it helps you so other community memebers can easliy navigate.

    Thanks

  • foodd's avatar
    foodd
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hello Anonymous, and thank you for sharing a question with the Community.  Please remember to adhere to the decorum of the Community Forum when asking a question.

    Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

    https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

    This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.