Skip to main content
Question

Power Bi connection failure

  • July 18, 2021
  • 0 replies
  • 152 views

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
------------------------------
This topic has been closed for replies.

Thanks for kicking this query off Xiaonan - I am experiencing the same anomaly with my Power BI refresh; the error message is the same "Expression.Error: The field 'sortBy' of the record wasn't found."

Curious to know if this is a wider systemic issue. I am running some 'mission-critical' reports leveraging data from my QB applications so the more people who engage with this discussion the more likely that it will be solved quicker.

- M. Carrington



------------------------------
Michael Carrington
------------------------------

  • Quickbase Alumni
  • July 19, 2021
Thanks xiaonan for mentioning this. I have also experience the same missing "sortBy" field issue for Power BI connection only starting from today. Since there are no any field called "sortBy" in my tables, seems it is a connector issue rather than a personal issue. Hope QuickBase could solve this issue soon. 

------------------------------
Alex Wong
------------------------------

Forum|alt.badge.img+7
  • Quickbase Alumni
  • July 19, 2021
I have the same problem, which is unfortunate as I'm rolling out PowerBI reporting for QB today!

------------------------------
Jeremy Anson
------------------------------

  • Quickbase Alumni
  • July 19, 2021
I am also experiencing the same issue with Power BI reports that had been refreshing fine before.
"The field 'sortBy' of the record wasn't found."

------------------------------
Katie McManus
------------------------------

  • Quickbase Alumni
  • July 19, 2021
Hi Xiaonan,

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


------------------------------
Daan Feijer
------------------------------

We are also facing same challenge. Hope it gets resolved soon as all our PBI boards are at a standstill.

Thank you in advance.

------------------------------
Apnesh Chauhan Gera
------------------------------

  • Quickbase Alumni
  • July 19, 2021
We are facing the same challenge. Thank you Xiaonan for kicking this off.

------------------------------
Mike Saffran
------------------------------

Forum|alt.badge.img+17
  • Community Moderator
  • July 19, 2021
Hi Everyone,

After this weekend we are having some customers running into issues with the Power BI connector. Our product team are working right now with Microsoft/Power BI to try to get to the root of the issue and I would encourage anyone who is running into this to put in a case with our Care team so they can see if you are being impacted by the same problem and let you know the status going forward. You can create a support case right here in community by clicking on Support where it appears in the global navigation at the top of the screen or you can create one in Quickbase by clicking the question mark ? icon that appears in the global navigation there and selecting Manage Support Cases. This will get you in touch with the team and they can collect some information from you as we work on this issue.

------------------------------
Evan Martinez
Community Marketing Manager
Quickbase
------------------------------

I'm having the same issue as everyone above. A lot of these reports are mission-critical so it would be great to have a solution very soon.

------------------------------
Stephen 
------------------------------

  • Quickbase Alumni
  • July 19, 2021
I'd like to throw my name into the mix as well. I thought I messed something up in my QuickBase app, but it seems to be working just fine.

I am also currently getting this error as well, I've submitted a Support Case.

------------------------------
Adrian Bogle
------------------------------