Forum Discussion

xiaonantang's avatar
xiaonantang
Qrew Member
3 years ago

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' ...
Integration
DaanFeijer's avatar
DaanFeijer
Qrew Member
Hi Xiaonan,

I'm facing the same challenge. Looking forward for a quick solution out of QuickBase!


------------------------------
Daan Feijer
------------------------------
DanielFozdar's avatar
DanielFozdar
Qrew Member
3 years ago

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
------------------------------