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, bu...
- 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
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