Query cancellation by PowerBI desktop

[Anonymous]

Hello Guyz,

I really would appreciate some experience here on why PowerBI desktop terminate my query session, when creating the data model and  I have no time out predefined, PowerBI desktop successful query the data source which is a data lake engine (dremio) to returns just 83 rows as shown below.

But when evaluating and creating the data model it cancel the query itself and try to establish a connection again.

The analysis above is from a dremio engine base on the query, I don't know if it will be helpful.

Please I would appreciate experiences and workaround.

Thank you,

Samson Eromonsei

[amitchandak]

@Anonymous , You can mention that in the advance property during connection creation or in power query

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459