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

Question

Hi ,&nbsp; &nbsp; I am having sharepoint list as source . It has some look up column(with multiselect) values in my main table .&nbsp; &nbsp; I am trying to pull it in power bi but the column type is something different .Thanks in Advance..

amitchandak · Answer

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 · Answer

Thanks for the reply&nbsp;amitchandak&nbsp;&nbsp; &nbsp;I had tried that .It says no column&nbsp;

amitchandak · Answer

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

ayappan · Answer

Hi&nbsp;amitchandak&nbsp;&nbsp; &nbsp; &nbsp;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&nbsp;&nbsp;Please help me to get this correctly&nbsp;amitchandak&nbsp;Thanks&nbsp;&nbsp;

ppm1 · Answer

Please see if this article helps. It provides a way to bring in data from lookup lists/columns.Updated – Get SharePoint List Data … Fast – Hoosier BIPat

Forum Discussion

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

6 Replies

Related content

Expression.SyntaxError: Token ',' expected.

Syntex Column In Sharepoint Folder

Sharepoint list mirroring

Extract Data from sharepoint

SharePoint Access