Power query is having timeout error when using complex query.

[Waynele]

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=fro... 

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. 

[MS_v-cuongtran]

We got critical impact from the customer that the impacted reports provide total cost of ownership for their IT department. Due to the issue, all reports are currently unavailable. Customer cannot use Synapse Link or Dataflows in their architecture.