Discussions

Expand all | Collapse all

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

George George11-03-2016 13:10

Archive User11-03-2016 16:31

txtMovies txtMovies11-12-2016 18:31

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

    Posted 10-26-2016 21:45
    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.


  • 2.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 10-27-2016 14:23
    I use QuNect to connect Power BI & my Quickbase app.


  • 3.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-02-2016 13:53
    Yes. I successfully retrieved a table of data using API_GenResultsTable.


  • 4.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-03-2016 12:46
    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!


  • 5.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-03-2016 13:10
    Yes ODBC


  • 6.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-03-2016 14:31
    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!


  • 7.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-03-2016 16:31
    You use URL / CSV as a Data Source, do you?


  • 8.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-08-2016 15:57
    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


  • 9.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-08-2016 18:56
    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,


  • 10.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-08-2016 19:59
    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?


  • 11.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-08-2016 20:29
    No, unfortunately I am not.  Any help would be greatly appreciated.  Thanks!


  • 12.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-08-2016 21:13
    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.


  • 13.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-12-2016 18:31
    I'll give it a try.  Thanks.


  • 14.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 11-14-2016 18:50
    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


  • 15.  RE: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?

    Posted 06-16-2017 19:08
    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