Forum Discussion

Fnoorda's avatar
Fnoorda
Frequent Visitor
8 years ago
Solved

Expanding Table after a merge

Hi, I have a little problem expanding table after a merge So here have three visualizations  All col Merge1 As you can see two record records match on the highlighted columns, but no rows in t...
Data Modeling
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi Fnoorda,

     

    I have test your issue, and it works after I merged two tables:

     

    One possible condition in your case is that the data type of columns in table All doesn’t  match the data type of columns in table Col. Please check if data types of columns are same in two tables.

     

    Please refer to my PBIX file: https://www.dropbox.com/s/clyn58d40vpphtn/For%20Fnoorda.pbix?dl=0

     

    Best Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Fnoorda,

 

I have test your issue, and it works after I merged two tables:

 

One possible condition in your case is that the data type of columns in table All doesn’t  match the data type of columns in table Col. Please check if data types of columns are same in two tables.

 

Please refer to my PBIX file: https://www.dropbox.com/s/clyn58d40vpphtn/For%20Fnoorda.pbix?dl=0

 

Best Regards,

Jimmy Tao

  • Fnoorda's avatar
    Fnoorda
    Frequent Visitor
    8 years ago

    Thanks Jimmy that does  solve the problem. Thanks for your help. Powerbi does seem to change the data type sometimes from whatever it is to this "any type"  I asume that equtes to variant.

     

    Thanks again.