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 ------------------------------1View6likes17CommentsQuickBase 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 supportquery 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 ------------------------------0Views1like0CommentsGravity 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 ------------------------------0Views1like0CommentsAPI 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.2Views1like4CommentsPowerBI 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 ------------------------------8Views1like6Comments