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. Locati...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Please accept it as a solution if it answers your need