Read Charges from PowerBI Connections
Per QB, in October QB changed the way that APIReads driven by PBI connections were being charged to accounts. We have been trying to get answers on what exactly changed and what kind of activity is dr...
Forum Discussion
Unfortunately, I have similar problem but reading Quickbase by DOMO.
1) Consume lots of reads
2) When DOMO reads my app performance drops dramatically, especially when we read tables with formula Queries.
------------------------------
Adam Krzyzanek
------------------------------
We are moving all of our PBI users out of Quickbase because of this. Instead, we use Qunect to export data changes daily to Snowflake and the PBI users now connect to Snowflake. Qunect can export data in batches of 2000 records at a time that counts as one read. It was not tenable to continue to allow users to connect directly to QB due to the way reads are being charged.
------------------------------
Sarah Weeden
------------------------------
- Mark has indicated exporting csv files from Quickbase via pipelines on a scheduled basis is a viable technical option - is there a financial cost associated with this approach?--
The process of building the CSV is all part of the QuickBase channel so there is no charge for using the channel or for the step runs. Uploading that file to OneDrive is just one step run so that's pretty minuscule.
I was under the impression that in a recent change Quickbase opened up our plans to be able to use our channels so I don't think there's a cost to using the OneDrive channel. But you might need to check with your Quickbase account manager for your particular plan level just to be sure of that.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- So it's seems a nightly export using pipelines to one or more csv files to a location where they can be accessed by Power BI is a viable no-cost option to avoid the charges discussed at the beginning of this thread.--
