Forum Discussion

PaulGrim1's avatar
PaulGrim1
Qrew Trainee
5 years ago

Quick Base user names loading into Power Query as codes

I've successfully connected Power BI to my Quick Base app, but when I retrieve the data there are two fields that show the username in Quick Base but load into Power Query as codes.  This is happenin...
Formulas and functions
Integration
TomMusto's avatar
TomMusto
Qrew Cadet
The codes you're seeing are what QuickBase actually uses behind the scenes to exactly identify a user. I would try using a Formula - Text field with the following formula: UserToName([Record Owner]). This should return a text string containing the user's name in the format "FirstName LastName".

------------------------------
-Tom
------------------------------
PaulGrim1's avatar
PaulGrim1
Qrew Trainee
5 years ago
That worked!  Thanks Tom!

------------------------------
Paul
------------------------------