Skip to main content
Question

Quick Base user names loading into Power Query as codes

  • November 14, 2019
  • 0 replies
  • 62 views

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 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:



------------------------------
Paul
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • November 14, 2019
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
------------------------------
Terms & ConditionsAccessibility statement