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 , All are detected as a table, use the small expand icon on the right of the column name and check what values it offers to expand

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

    Thanks for the reply amitchandak 

       I had tried that .It says no column

     

    • 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