Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Powerbi table connection

In powebi, in linking tables and model view, I can't link 3 tables. Can you help me? The 3 tables are "sales table", "customers table" and "objectives table". The “sales table” is linked to the “cust...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    After reviewing the provided screenshot, we identified a potential data type mismatch between the Datum[Date] column (formatted as DateTime) and the Objectifs promoteurs[Mois] column (formatted as Date). This inconsistency could contribute to errors when establishing relationships between the tables.

    To expedite troubleshooting, could you kindly share a simplified .pbix file that replicates the issue? Please include a brief description of the expected outcome in the file or your response. This will allow us to:

    1. Validate the root cause of the relationship error.

    2. Replicate the scenario and test solutions efficiently.

    You can securely upload the file using the community portal here:
    How to upload PBI in Community

    Note: Ensure sensitive data is removed or anonymized before sharing.

    Thank you for your collaboration. We’ll prioritize resolving this once we receive the sample file.

    Best Regards

danextian's avatar
danextian
Super User
1 year ago

Hi Anonymous 

What you're attempting to do will create ambiguity. Vente is already linked to Clients, and Clients are connected to Objectifs. If you establish a direct relationship between Vente and Objectifs, it will result in a circular relationship. When using columns from these tables, it becomes unclear which relationship will take precedence: Vente to Clients/Objectifs, Objectifs to Clients/Vente, or Clients to Vente/Objectifs.