Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
We have serveral Power BI reports on the Power BI Service that are shared, they auto refresh every day, however most days the timeout, with this error;
{"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","parameters":{},"details":[]}}} Table: Merge1.
I just keep manually re-running the refresh until it works.
I would like to solve this issue, can anyone tell me where to start?
Regards
GrahamR99
My issue resolved after admin restarted the gateway. He also downloaded and installed newest version out there. No problem with auto-refreshes or scheduled refreshes so far. If the data pull is complex enough for request to time-out, have you considered incremental refresh? I did that with 2 of my reports and no issues with time-out now - but this is a specific situation where I know the reason behind the error. It was 56 million+ records and loading through a compelx SQL view. Please try that and update here to see if it resolves your problem?
Hi @RoopaR @GrahamR99 @alex_j
Sometimes timeout issues occur, due to the server being busy.
When Power BI reads the table, at the same time same table is used to write data or other reports reading data from the same table.
Please look into the data model which table uses same time refresh, optimize your report, how much time it takes when the server is not in use, etc
If you face the same issue, please try to connect to Microsoft support
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, Like 👍 this comment
Thanks
Pijush
Hi @RoopaR @GrahamR99 @alex_j
After troubleshooting the below information,
When Power BI reads the table, at the same time same table is used to write data or other reports reading data from the same table.
Please look into the data model which table uses same time refresh, optimize your report, how much time it takes when the server is not in use, etc
If you face the same issue, please try to connect to Microsoft support
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, Like this comment
Thanks
Pijush
Do either of you have a resolution to this? I have the same problem as well. I had the admin restart the gateway installed on-prem and then all refreshes went fine, but looks like its disconnected again from SQL server and my datasets aren't able to connect to SQL server via gateway while the gateway itself shows online in Power BI service
Hi @GrahamR99
Please try to put the report in a different refresh schedule time like the example below
1. One large dataset report, kept at 7.00 am
2. Two medium dataset reports at 7.30 am
Dont keep all reports in same time slot
Check your report performance issue and optimize your report
Search Google for "how to optimize power BI reports" and learn
Hello @PijushRoy
I have already tried different times, and that didn't work. I have 7 reports auto refreshing 5 refreshes at 7:30am, one at 8am and one at 8:30am the two that run after 8 are the ones failing.
Is there no better solution than the time it runs, our organisation is planning to increase the amount of Power BI reports massively and if it can handle two reports now what's it going to be like in the future?
These reports that fail are not large datasets either, they are 500MB at most at a guess, still trying to work that out, but need Microsoft Fabric to work out and we don't have that yet.
Is there anything better you can suggest?
Regards
GrahamR99
I have the same here. Dataset has 500mb. Sometimes the refresh works, sometimes it doesn't.
Sometimes takes 1 hour, and sometimes 2 hours.
It's really hard to track where the bottleneck is.