When users try to use a query that include *select, FROM, JOINS function in the command, they will recieve a timeout error message. We understand that this is an expected behavior from this article: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query#:~:text=from%20optimizing%20queries.-,Limitations,-The%20Dataverse%20TDS However, there are some situations that users need to use these funcitons to query out the data that they need and it is not optimal if we do not allow them to execute those kind of queries.
... View more