Forum Discussion

solrus's avatar
solrus
New Member
5 years ago
Solved

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.  

  • Anonymous's avatar
    Anonymous
    5 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

  • Anonymous's avatar
    Anonymous
    Not 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Please accept it as a solution if it answers your need