Forum Discussion

PaulGrim1's avatar
PaulGrim1
Qrew Trainee
6 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
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago
Paul,

I am not sure how the connector translates those User fields.   That is a strange response.   

Temporarily make a Formula User field and set it equal to [Record Owner]
See if that will give you the correct data through the connector.

If that fails, I have another solution for you.  We built a tool called Paasporter that extracts your Quick Base data and will index it into a SQL Compliant DB.  Now you do not need the connector.  You use that DB as your data source and can join it across the other data sources you are using to build your visualizations.

Happy to demo it for so you can see the utility of SQL for your complex reporting.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
PaulGrim1's avatar
PaulGrim1
Qrew Trainee
6 years ago
Hi Don,

Thanks for the offer to help.  I tried your suggestion but it just pulls the same code into Power BI.  I will have to look at it again tomorrow to see if I can somehow convert it to a textual user name. I'm new to QB so still exploring its capabilities and limitations.

------------------------------
Paul
------------------------------
  • TomMusto's avatar
    TomMusto
    Qrew Cadet
    6 years ago
    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
      6 years ago
      That worked!  Thanks Tom!

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