I want to change the setting of the gateway data refresh timeout.

[Anonymous]

hi, guys.

I'm querying from a table with about 12 million records.

It will be easy to understand if you refer to what you wrote before.

https://community.powerbi.com/t5/Desktop/ORA-01013-I-want-to-change-the-query-timeout-setting/m-p/45...

It takes five hours to load the data.

so, If I refresh the data after installing a gateway, it fails to timeout after two hours.

I want to change the gateway timeout setting.

I tried.

Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config

           <setting name="MashupDSRTestConnectionTimeout" serializeAs="String">
                        <value>00:00:50</value>     ------changed----->     <value>10:00:00</value>

but, failed.

Please help......

[MaddogMikeB_A_G]

Do it it batches 

SELECT need columns

FROM table
WHERE out_date > ADD_MONTHS(SYSDATE,-12)

SELECT need columns

FROM table
WHERE out_date > ADD_MONTHS(SYSDATE,-24) AND out_date < ADD_MONTHS(SYSDATE,-12)

Then join using DAX with a UNION and hide the two original tables 

[Anonymous · Accepted solution]

HI @Anonymous,

Power bi service has its own query timeout property, the maximum number is 120 minutes. You can consider to upgrade your license to premium to increase maximum timeout.(240 minutes)

Power BI Premium support for large datasets

Scheduled refresh of large datasets can take a long time and be very resource-intensive. Accordingly, do not schedule too many overlapping refreshes. Notice also that the timeout for scheduled refresh jobs has been doubled to four hours for all datasets in this capacity.

In addition, this timeout means queue and execute timeout, it not means refresh duration. 

Regards,

Xiaoxin Sheng

[Seth_C_Bauer]

@Anonymous Do you have any options to 1) reduce the columns returned to only those you need. "Select *" is the devil. Unless all the columns are coming from a view... 2) You could work to break the query up into seperate queries for different time ranges then combine them together... this may take more memory, but could reduce the overall time. 3) Do you have the ability to spin up a SSAS Tabular model? 

[Anonymous]

1) Select * is not used.......

2) I used this

SELECT need columns

FROM table
WHERE out_date > ADD_MONTHS(SYSDATE,-24)

3) I don't have ability.....

Can not set timeout time?

p.s English is not a native language. so, the grammar can be strange.