Jul 29 2022 01:07 AM - edited Jul 29 2022 01:08 AM
Hello,
We have developed Power BI reports using CQD datasets. The visuals have been loading properly most times since its launch last year.
However we are currently experiencing errors to load most of the visuals for more than a week now. We have not changed anything prior to that.
Error: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3).
Any idea why?
Start Time is also problematic. It does not load.
Jul 31 2022 07:07 AM
Solution
Thanks for calling this one out. It could be a number of things, but the fact you haven't changed anything and then it suddenly has issues rendering means that it is likely Microsoft's end. They do work on the back end all the time, it's typically the underlying reason if, say, a functionality changes or there is something like latency in the Teams Admin Centre
You could wait for it to resolve out, but the recommended course of action on this one would be a ticket up to Microsoft support. I have checked CQD on some of my tenants and all looks in order, so they will need to investigate this with you. What would be cool is, once you have an underlying cause confirmed, to put it back here so the community can understand for future reference
Thanks again, best, Chris
Aug 04 2022 11:12 PM
Jul 31 2022 07:07 AM
Solution
Thanks for calling this one out. It could be a number of things, but the fact you haven't changed anything and then it suddenly has issues rendering means that it is likely Microsoft's end. They do work on the back end all the time, it's typically the underlying reason if, say, a functionality changes or there is something like latency in the Teams Admin Centre
You could wait for it to resolve out, but the recommended course of action on this one would be a ticket up to Microsoft support. I have checked CQD on some of my tenants and all looks in order, so they will need to investigate this with you. What would be cool is, once you have an underlying cause confirmed, to put it back here so the community can understand for future reference
Thanks again, best, Chris