Extract Data from QuickBase to Use in PowerBI
I need to extract data from QuickBase on a regular basis (ideal would be every 10-15 minutes into a SQL based analytical data model for consumption by PowerBI dashboards and reports. As I understan...
Forum Discussion
What's triggering the changes in the QuickBase app that need to be reflected in PowerBI every 10-15 minutes? Is it new/changed records within the app by human user action? Or an API action or sync update?
If it's user action, you could possibly use the form to inject a script that would (1) transform the data into CSV and (2) make a third-party API call to write it somewhere PowerBI could read it without needing to make a QuickBase API call. I'm not sure about the feasibility of this, but if Qunect isn't the right solution and you must limit the QuickBase API calls, I would investigate this further.
If it's user action, you could possibly use the form to inject a script that would (1) transform the data into CSV and (2) make a third-party API call to write it somewhere PowerBI could read it without needing to make a QuickBase API call. I'm not sure about the feasibility of this, but if Qunect isn't the right solution and you must limit the QuickBase API calls, I would investigate this further.