Forum Discussion

afaque03's avatar
afaque03
Helper I
8 years ago

Excel and datasbase data does not get realted.

Hi Need Help,

 

I am stucked in an issue where I have one spreadsheet as dataset and I have a SQL query which is bringing data. In both these data set I have Product name and when I create relationship between two column of product name the relationship of mmany to one gets created but when I pull data from query and the other field from spreadhseet then one of the column becomes null.

 

I have apnneded 4 spreadhseet together and made it one in Power BI level. In this Append 1 is the sheet which I have appended and Query1 is from where Iam getting the data in SQL.

 

When I drop the product field from Append1 and Product filed from Query 1 then th putput I get is

I have hidden the name of the product but the aboove issue is what Iam facing.

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    afaque03,


    Could you please share sample data of append1 table and Query1 table here? Does the Append1 table contain all the possible product name values of Query1 table?

    Regards,
    Lydia

    • afaque03's avatar
      afaque03
      Helper I
      8 years ago

      AnonymousNo the no. of prooduct in query is more as compared to the no. of product in Append.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        afaque03,

        The issue is related to the values. Please create a new bridge table containing all possible product name values of Append table and query table, then delete the existing relationship between append and query tables, create relationship between bridge table and append table, and create relationship between bridge table and query table.

        Regards,
        Lydia