Reporting on Text Field from SharePoint List (vs. ID)

[solrus]

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.  

[AntoineTRICHET]

Please accept it as a solution if it answers your need

[AntoineTRICHET · Accepted solution]

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