Forum Discussion
Reporting on Text Field from SharePoint List (vs. ID)
Hello,
I'm new to Power BI, but I've built a bunch of SharePoint Lists that all reference two lookup columns:
1) Full Name - e.g. Full Name - ID = 1; Text = Jane Doe
2) Location - e.g. Location - ID = 1; Text = 123 Street, City
Now I'm trying to build reports in Power BI, but it only pulls in the ID and not the associated text.
Is there a way to show the text vs. the ID in Power BI? I'm hoping it's a simple setting that I can adjust vs. having to build an associated look-up table.
- Anonymous5 years ago
Hi solrus
If you used Sharepoint online list connector your query should have a column named FieldValuesAsText. You just have to expand this column & expand it choosing the fields you are searching for (see screenshot below).
I hope it will help you
2 Replies
- AnonymousNot applicable
Hi solrus
If you used Sharepoint online list connector your query should have a column named FieldValuesAsText. You just have to expand this column & expand it choosing the fields you are searching for (see screenshot below).
I hope it will help you - AnonymousNot applicable
Please accept it as a solution if it answers your need