BI doesn't read LookUp Value from SharePoint

[Anonymous]

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

[Greg_Deckler · Accepted solution]

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.

[andreaperolo86]

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

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Have you tried to click the following icon to expand the table? Is there any error message?

Best Regards

Allan

[Anonymous]

@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

[drwhit]

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

[Greg_Deckler · Accepted solution]

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.