Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Ayappan
Helper III
Helper III

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 different .

Ayappan_0-1672139267789.png

Thanks in Advance..

6 REPLIES 6
ppm1
Solution Sage
Solution Sage

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 BI

Pat

Microsoft Employee
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for the reply @amitchandak 

   I had tried that .It says no column

Ayappan_0-1672141927846.png

 

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak 

     

Ayappan_0-1672145521270.png

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 

Ayappan_1-1672145656388.png

 

Please help me to get this correctly @amitchandak 

Thanks 

 

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors