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!