Connecting Quick Base to Power BI using API- GenRsultsTable

  • 0
  • 2
  • Question
  • Updated 6 months ago
  • In Progress
Photo of Raj Helaiya

Raj Helaiya

  • 1,550 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 2
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,658 Points 10k badge 2x thumb
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. 
Photo of Raj Helaiya

Raj Helaiya

  • 1,550 Points 1k badge 2x thumb
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. 
I would love that too!
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,478 Points 10k badge 2x thumb
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. 
Photo of Raj Helaiya

Raj Helaiya

  • 1,550 Points 1k badge 2x thumb
Allright, maybe Jacob McIntyre could help. 
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,478 Points 10k badge 2x thumb
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?
Photo of Madan Kumar

Madan Kumar

  • 60 Points
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.
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