Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Interested in using Power BI for analytics on my Quickbase tables.

Has anybody figured out a way to connect Power BI to quickbase?

Thanks in advance.
Photo of txtMovies

txtMovies

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of George

George

  • 180 Points 100 badge 2x thumb
I use QuNect to connect Power BI & my Quickbase app.
Photo of Erich

Erich

  • 0 Points
Yes. I successfully retrieved a table of data using API_GenResultsTable.
Photo of Alvaro

Alvaro

  • 0 Points
Hi George! We are currently looking for something like this. ¿How did you set up QuNect in Power BI? ¿As a ODBC? Thanks in advance!
Photo of George

George

  • 180 Points 100 badge 2x thumb
Yes ODBC
Photo of Alvaro

Alvaro

  • 0 Points
Thanks for your reply. Can you provide me some help in this? I have been working in this for weeks and still not able to connect. I don't know if I should set up something in QuNect beside the following settings: https://s18.postimg.org/vt4dhny09/Conexion_actual_Qunect.png . Thanks in advance!
Photo of Alvaro

Alvaro

  • 0 Points
You use URL / CSV as a Data Source, do you?
Photo of Erich

Erich

  • 0 Points
Yes. Get Data > Web from Power BI. I don't think that the options=csv is necessary, but you'll have add authentication to QB
Photo of txtMovies

txtMovies

  • 0 Points
Hi Erich, thanks for the post....i'm not that technical but looked up the API_GenResultsTable function.  This is what i found.  

URL alternative
https://target_domain/db/target_dbid?a=API_GenResultsTable&ticket=
auth_ticket&apptoken=app_token&qid=5&jht=1&query=
{'6'.CT.'done'}AND{'14'.CT.'USA'}&clist=7.8&slist=6&options=sortorder-A

where target_domain is the domain against which you are invoking this call, for example, intuit.quickbase.com. Read about this notation.

Can you please confirm that this is how you are connecting to a table with Power BI?

Thank you in advance,
Photo of Erich

Erich

  • 0 Points
Yes, that is the format I'm using. Are you familiar with how to use API_Authenticate to get the "auth_ticket" needed for the GenResultsTable call?
Photo of txtMovies

txtMovies

  • 0 Points
No, unfortunately I am not.  Any help would be greatly appreciated.  Thanks!
Photo of Erich

Erich

  • 0 Points
Here is a complete URL that will retrieve an entire table of data.  Just replace the 5 variables that start with "YOUR" with your information and paste the entire string into the URL box in Power BI:

https://YOUR_DOMAIN.quickbase.com/db/YOUR_TABLE_ID?a=API_GenResultsTable&apptoken=YOUR_APP_TOKEN&ticket=API_Authenticate&username=YOUR_USERNAME&password=YOUR_PASSWORD

Note: While this will work, it is not the most secure. Your credentials are stored in plain text.
Photo of txtMovies

txtMovies

  • 0 Points
I'll give it a try.  Thanks.
Photo of cvonroesgen

cvonroesgen

  • 20 Points
Please download the latest version of QuNect ODBC for QuickBase to get connectivity with Power BI.
https://qunectllc.com/download/QuNect.exe
Please call if you have any questions:
978-405-2524
Photo of cvonroesgen

cvonroesgen

  • 20 Points
Just discovered that if you have two or more relationships to the same parent table then PowerBI chokes if you try to use the application/table chooser UI. Instead you'll need to use advanced options. Please watch the following video to see an example of how to do this. http://qunect.com/appnotes/PowerBI.html