Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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!
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.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.