Discussions

Expand all | Collapse all

Connecting Quick Base to Power BI using API- GenRsultsTable

  • 1.  Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 06-19-2018 20:02


  • 2.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 06-21-2018 17:23
    Hi Raj,

    I am not myself familiar with how to connect Power BI to Quick Base making use of the API_GenResultsTable call but we actually had a session this year at Empower that was focused on making use of Power BI and Quick Base data that was run by one of our CSMs. It is hosted in our Quick Base University:

    Quick Base and Power BI-Better Together

    It goes over creating a connection between Quick Base and Power BI and could be a great resource to start with. 


  • 3.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 07-09-2018 15:31
    Hello Evan, I attended the session in EMPOWER. I used the code given in the presentation resources, but somehow I am not able to connect my application with Power BI. I was wondering if there are any experts who can guide me to do the same. 


  • 4.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 07-09-2018 15:34
    I would love that too!


  • 5.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 07-09-2018 16:14
    I am looking into more information and getting some more resources on the Quick Back to Power BI connection up and running. I don't know much beyond what was in the presentation myself but I'll see if I can't get anything more definitive since I know the Care Team won't have experience with this to help you out with debugging it. From memory of the presentation I do know there are some Security elements that also have to be in place besides the call, and that it does need to be tailored a bit to your apps specifics. 


  • 6.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 07-09-2018 16:41
    Allright, maybe Jacob McIntyre could help. 


  • 7.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 07-12-2018 15:41
    That is one of the resources I am reaching out to Raj. Do you get a specific error message when you are attempting to connect to Power BI with the call in Jacob's presentation? Do you also have all the security changes in place that he recommended for the process to work?


  • 8.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 08-06-2018 02:47
    The method proposed at Empower, as Jacob mentioned, is limited:
    You can only access a single table report with a max of 66,000 records and it isn't "realtime". If you are looking to evaluate powerBI you could export an excel spreadsheet from Quick Base and load it in to powerBI. 

    We at CloudBase have been integrating Quick Base with BI systems for years.  As solutions partners of both Power BI and Quick Base, we can help if your needs go beyond just loading a table report to powerBI. Feel free to contact us through our website.


  • 9.  RE: Connecting Quick Base to Power BI using API- GenRsultsTable

    Posted 02-19-2019 17:47
    Microsoft just released the Quick Base Connector to Microsoft Power BI.

    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2019-feature-summary/

    Power BI Desktop Update - February 2018
    https://www.youtube.com/watch?v=KeVB5RwMzJo


    quick basePNG