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

I use QuNect to connect Power BI & my Quickbase app.

Yes. I successfully retrieved a table of data using API_GenResultsTable.

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!

Yes ODBC

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!

You use URL / CSV as a Data Source, do you?

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

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,

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?

No, unfortunately I am not.  Any help would be greatly appreciated.  Thanks!

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.

I'll give it a try.  Thanks.

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

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