Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 .
Thanks in Advance..
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
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
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
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |