Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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......
Solved! Go to Solution.
HI @ted_kim,
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
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
HI @ted_kim,
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
@ted_kim 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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.