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.
Dear all,
I've been getting the following refresh fails on random tables.
On all my tables, i have inserted the following as an attempt to avoid timeout errors but I'm still getting them.
Most of my tables are an "Append Query as new" in which I'm combining 4 tables and I deactivate "Enable load" on the 4 tables. The above code is on the 4 tables but not on the Appended.
I hope that this makes sense.
Does anyone have an idea of what the problem is here?
Thanks in advance
Hi @setis ,
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!
Best Regards,
Yingjie Li
@v-yingjl unfortunately the issue is not fixed.
The settings you suggested were already in the gateway and I have an open ticket with MS that has received the gateways logs.
I will update the thread with their findings if there is a solution.
Hi @setis ,
With that said in the DataMovement.Pipeline.Gateway config file you can edit this settings to your desire value to see if this resolves you problem.
</setting>
<setting name="DbConnectionPoolMaxSize" serializeAs="String">
<value>256</value>
</setting>
If not help, I would recommend you create a support ticket here .
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
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.