Quick Base user names loading into Power Query as codes

[Anonymous]

I've successfuly 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 happening in the "Last Modified By" and "Record Owner" fields.  So instead of "John Doe" (which is what I see in the Quick Base app) I might see "32598325.fb7x".  Is there any way to pull the actual user name into Power Query, or is this some kind of intentional restriction on the Quick Base side?  Here is an example:

[dax]

Hi pgrim, 

Based on my research, I find that this is a limitations, you could refer to PowerBI-to-Quickbase-User-Names/  and Pull Quick Base Data into Power BI with the New Connector  for details.

So I think you need to create a new table with username and userid manually, then you could create relationship between these two tables.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi Zoe.  The solution was actually even easier than that.  You simply create a new field in your table with the format "Formula - Text", then give it the formula "UserToName([Record Owner])".  The user's name then appears in your reports as "FirstName LastName".  

Thanks for helping out!

[dax]

Hi pgrim, 

It seems that you solve this problem, right?  If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.