Azure SQL DB Load Error - Execution Timeout Expired

[Anonymous]

Hello,

I'm trying to load data from Azure SQL DB. When I pull full data by SQL Query then its working fine but when I try to load the data by max date query it's providing me error showing Execution Timeout Expired.

Both the queries are working fine in SQL Server but the last query is not working in Power BI Desktop.

I tried to put 60 minutes timeout but still its not working.

The working Query:

select * from table1

union all

select * table2

union all

select * from table3

The query which I'm facing issue in Power BI Desktop:

select * from table1 where date = ( select max(date) from table1)

union all

select * from table2 where date = ( select max(date) from table2)

union all

select * from table3 where date = ( select max(date) from table2)

[v-danhe-msft]

Hi @Anonymous ,

It seemed your data of your size is too large that the Power BI could not run in time. Have you tried to make the amount of data smaller? If the query could run well in sql server, I suggest you run in sql server firstly then you could import the data to Power BI.

Regards,

Daniel He