Power Bi connection failure
I have a scheduled Power BI refresh from one of the QB reports, it has been working well for many months, but starting today, it keeps giving me this message: Expression.Error: The field 'sortBy' of the record wasn't found How do I solve this? Thank you! ------------------------------ xiaonan tang ------------------------------
Connecting Quickbase to AWS for Sentiment Analysis
Quickbase is uniquely positioned to solve numerous business problems because of both the product's incredible flexibility and the different approach to how people build applications on the platform. The problem solvers who use the tool can resolve critical business challenges themselves in days and even hours on a system that IT trusts and can govern at enterprise-scale. Although powerful in business users' hands, the technically inclined can elevate Quickbase to new heights by integrating it with other systems through extension points such as Pipelines, Quickbase's native integration platform. Public cloud providers like Amazon Web Services provide many building block services that go together with Quickbase like peanut butter and jelly, and I want to introduce a sentiment analysis capability for Quickbase using Pipelines and AWS as a working example of this power. The Amazon piece is available at https://github.com/cpliakas/quickbase-sentiment-analysis, and developers can replicate the pattern for other AWS services as well. As context, Quickbase applications often capture data at the edge of the business. The more data that is captured, the more important it is to automate data analysis to extract insights from it. For example, let's say you want to crowd-source inspection of inventory, products, etc. The goal is for employees to snap pictures and submit comments when they happen to notice something in the field, such as an example of a great product display or a misplaced item. Within minutes, you can create a Quickbase application that is mobile-ready and able to be used in the field. A welcomed problem is when the application becomes widely used across the organization, and manual analysis of the data becomes impractical. One way to start categorizing the data is through sentiment analysis of the comments to sort the feedback into positive, negative, and neutral submissions to determine which ones to act on first. This situation is where our example comes into play. Amazon has a service called Comprehend that provides sentiment analysis. At first glance, the integration appears to be dead-simple. However, many hidden complexities around authentication and infrastructure configuration take time to figure out. The project at https://github.com/cpliakas/quickbase-sentiment-analysis provides a one-click install of the Amazon piece of the puzzle through the Serverless Application Repository that has Quickbase assumptions which make it really easy to securely integrate with Quickbase through Pipelines. The video below walks through an end-to-end setup so that you can start experimenting with the capability now. The https://github.com/cpliakas/quickbase-sentiment-analysis project is released under the permissive open-source MIT license. You are free to use and copy the tool and apply the patterns in whatever manner you wish, including commercial applications where people pay for your service. I hope you find it useful, and I look forward to learning about where the tool and techniques are providing value to your Quickbase applications. ------------------------------ Chris Pliakas ------------------------------
QuickBase interaction with PowerBI's incremental refresh
I have my QuickBase apps connected to Microsoft PowerBI. The issue is that when I set up PowerBI to automatically refresh the data from QuickBase, the system times out before it can be completed. I am going to upgrade to PowerBI Premium Per User which offers incremental refresh capabilities, BUT it needs to be connected to a back-end system that supports Power Query's query folding requirements. Here's a summary of what Query Folding is: Query folding - Incremental refresh is designed for data sources that support query folding, which is Power Query's ability to generate a single query expression to retrieve and transform source data. Most data sources that support SQL queries support query folding. Data sources like flat files, blobs, and some web feeds often do not. Microsoft Documentation: https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview The question I have is whether QuickBase will support query folding. ------------------------------ Warren Willits ------------------------------
Gravity Forms > Zapier > 2 Quickbase Tables
Our Wordpress website uses Gravity Forms and I use Zapier to bring the data into Quickbase. The issue I am having is it is creating a Company Name (in the Companies Table) and saving Contact info (in the Contacts Table) but I can't figure out a way to relate the company to the contact automatically. I currently have an extra field in the Contacts table that pulls in the company name and then I can manually link the related company. Can anyone think of a way to relate this automatically with a webhook, automation, etc? ------------------------------ Mark Comish ------------------------------
API Export of Dates
I'm connecting a BI tool called Grow to Quick Base and see that all non-time stamp date field are coming over in UNIX-13. The funky thing is when I convert this all fields convert properly except one field shows the converted result as some records being 1 hour behind the accurate result. Any ideas why this is? *This is only a date entry field, not a formula field. In this case: 19:00:00 is the correct time. Once I get this figured out then I do a time-shift of +5 hours to get it back to midnight.
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 ------------------------------
