Forum Discussion
BI doesn't read LookUp Value from SharePoint
Hello team,
I have SP list called MY DATA with 3 fields (ID, Name, and My Impacts). My Impacts is a Lookup type (Allow multiple Values), which look up from another list.
I import MY DATA to BI, but the My Impacts field doesn't show data, but a table, and I couldn't expand it to get the data.
What is the issue and solution here.? Thank you
- No sure why you cannot expand it, it should hold an ID for the item in the other table. You will need to load the other table unless you know what the ID's mean.
Hi, Anonymous
Have you tried to click the following icon to expand the table? Is there any error message?
Best Regards
Allan
5 Replies
- Greg_Deckler
Community Champion
No sure why you cannot expand it, it should hold an ID for the item in the other table. You will need to load the other table unless you know what the ID's mean. 
v-alq-msftCommunity Support
Hi, Anonymous
Have you tried to click the following icon to expand the table? Is there any error message?
Best Regards
Allan
v-alq-msft Thanks for your response. I tried but it didn't allow me to do that. I read some articles and noticed that BI doesn't look Lookup type in Sharepoint.
I found the solution for this. it didn't load the Lookup value but it loaded the ID associated with values. I need to import the original data first. Then create the connection between 2 tables. Next, write an ELSE IF function to bring the values that associated with ID.
Thanks
When you hit that expand button, select expand new rows. Then hit the expand button again and select only the lookup value.
PLease select as the solution if this solves the issue, thanks.
-DW
Hi, you can use OData Feed (with URL for the SharePoint "http://siteurl/_vti_bin/listdata.svc" ) instead th standard SharePoint data connection, in this case you'll be able to see all Lookup values in the MyImpacts Table. 😉
Andrew
