Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |