Forum Discussion

Ayappan's avatar
Ayappan
Icon for Helper III rankHelper III
3 years ago

Column Type is not as expected - Power BI - Sharepoint Source

Hi ,     I am having sharepoint list as source . It has some look up column(with multiselect) values in my main table .     I am trying to pull it in power bi but the column type is something diffe...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Ayappan , Strange.  In each row, click on empty space near the table (where the table is written), it should show you the table

Ayappan's avatar
Ayappan
Icon for Helper III rankHelper III
3 years ago

Hi amitchandak 

     

In this table i am getting the id of the selected value ..i had mapped with Id of Lookup table and Main Table ..I am not getting the correct values 

 

Please help me to get this correctly amitchandak 

Thanks 

 

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    3 years ago

    Hi Ayappan ,

    In this case, your 1, 38 in EquipmentTypeID column looks for the same entry in your ID.1 Column of the Equipment_Types table.

     

    In your expected table, if you see, field is getting returned for I = 1, but not for ID = 1,38. In addition, in your table, all comma separated IDs have return NULL as field value.

    Although you have separate records for 1 and 38 IDs, since 1, 38 is not a single ID it won't work.

    Would suggest that you check such that either the comma separated values are split into two separate rows or the lookup table ID should have comma separate Values

     

    Hope this solves your issue