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' ...
Forum Discussion
Hi Xiaonan,
I'm facing the same challenge. Looking forward for a quick solution out of QuickBase!
------------------------------
Daan Feijer
------------------------------
I'm facing the same challenge. Looking forward for a quick solution out of QuickBase!
------------------------------
Daan Feijer
------------------------------
Also same here. For everyone needing an urgent way around this: as a workaround, you can get PowerBI to use a Web connection, with URL = https://[SITE].quickbase.com/db/[APPID]?a=api_genresultstable&qid=[QUERYID]&options=csv&usertoken=[YOUR_USERTOKEN]
(You can get Query ID by logging in to QuickBase, navigating to your table, expand 'Reports & Charts', and then pick either the report you want, or List All if you're not sure. List All typically defaults to Query ID = 1)
------------------------------
Dan
------------------------------