Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Serialized or prioritized running of query refresh

I have a report that obtains data from multiple REST API operations on the same server. There are no dependencies between the queries. When refreshing the queries in Desktop or in the Gateway, I get an error "cannot convert to type Record" which is bogus as the error wanders from uery to query randomly. Each query will run fine by itself, it is only when all the refresh operations are started in parallel that the error occurs. Apart from being annoying it prevents timed data refresh. If it were possible to specify a running order for the queries I suspect that this issue could be avoided.
Status: Needs Votes
Comments
spencerl
New Member
This would help us too. Because Oracle does not support uncommitted reads parallel queries against the same database can create a big performance hit related to "latch: cache buffers chains".
fbcideas_migusr
New Member
Status changed to: Needs Votes