ContributionsMost RecentMost LikesSolutionsRe: Read Charges from PowerBI Connections 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 ------------------------------ Re: Read Charges from PowerBI ConnectionsHi Don, I think it depends on the question (if you want to share I can try to help) and if they are on the new subscription model which is based on reads. With the new subscription model, QB consolidated billable reads from an account perspective (a read being anything from a user looking at report, to a pipeline step). This simplifies billing but requires a bit more data management for analysis and tracking trends or anomalies, especially with the move from automations to pipelines. Proactively tracking all of the reads per app, per pipeline, per week, and watching for anomalies is important but also informative for renewals in case you know you are going to need to increase your subscription allotments. As far as PowerBI specifically, we have had to move data out of QB into a separate database for PowerBI users, because most user activity in power query is charged as a read, and it was eating a huge portion of our allotments. Hope that helps. -Sarah ------------------------------ Sarah Weeden ------------------------------ Re: Read Charges from PowerBI ConnectionsAs per QB: An Integration Read is: An API call sent from a 3rd party system, that involves a read of data from Quickbase An API call that requests record information from Quickbase, whether 1 record, 100 records, or 1M records. QB has not provided threshold limits after which data would be paginated. ------------------------------ Sarah Weeden ------------------------------ Read Charges from PowerBI ConnectionsPer 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 driving the charges, because they don't directly align with obvious user activity. Users are connecting to PBI via reports and the dashboards have auto-refreshes of once a day (generally). However we are seeing APIReads in excess of 100+ a day per user. A Solution Architect did some tests with PBI and she said that the following resulted in multiple reads per action: Refresh preview (4 reads) and saving (2 reads). She also said that based on the size of the data the results would be paginated, resulting in more reads (however, the documentation online says "1 read regardless of the number of columns/rows"). It is also possible that the steps in power query are all being counted as Reads. Has anyone else encountered this issue or been able to determine what activity in PBI is driving high read counts? If QB provides answers to this I will update the thread. ------------------------------ Sarah Weeden ------------------------------Hiring Quickbase Developer at EagleViewHello Quickbase community! EagleView is hiring a Quickbase Developer - Come join the team! https://hrbrg.co/wbiifr ------------------------------ Sarah Weeden ------------------------------ Re: PowerBI access forbidden to Quick BasePost-release update: QBE015141: Non-admin users can now make API requests to getTables and access tables to which they have permission. https://help.quickbase.com/release-notes/january-2021-release-notes.html This unfortunately has not resolved the problem for us. ------------------------------ Sarah W ------------------------------ Re: PowerBI access forbidden to Quick Base This has been identified as a bug on Quick Base's side. They have said there will be a fix in the next release. Bug ID: QBE015131 Next release date: 1.10.21 ------------------------------ Sarah W ------------------------------ Re: PowerBI access forbidden to Quick Base This is definitely an issue specific to the December PBI release. After updating desktop no one is able to refresh QB connections, they all get a forbidden error. #pbi #pbidecember2020 #PowerBI #pbiconnector ------------------------------ Sarah W ------------------------------ Re: PowerBI access forbidden to Quick Base I do have a case open with QB but no solutions yet - will update here if there are any provided. ------------------------------ Sarah W ------------------------------ PowerBI access forbidden to Quick Base Have other people been suddenly encountering the problem of "Access Forbidden" to Quick Base via PowerBI? The thread below implies it is a Quick Base problem and not the PBI connector. https://community.powerbi.com/t5/Service/Scheduled-refresh-not-working-Quick-base-Invalid-Credentials/m-p/1557637#M116258 ------------------------------ Sarah W ------------------------------