Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Frequent issues with Dataset refreshes across different workspaces in power bi



There has been frequent refresh failures with following error message:

Data source error:

{"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: XXXX.

This happens randomly across different workspaces and for different tables. (DB source type: SQL Server)


What are the settings that can be checked?

What are the best practices that can be followed?


Any suggestions will be really helpful.


Frequent Visitor


I know this is an old post. Just wanted to provide certain inputs that may be useful.

- Restart the capacity (Premium capacity)

- Disable any AI related options if that is not being used
- Setup the Capacity workload based on requirement

- Schedule large datasets at certain times to minimize conflicts with other refreshes.

- Use dataflows to avoid reprocessing the same data in multiple datasets.
- Use Power BI datasets direct query datasets to reuse datasets in reports.
- Also Power BI models needs to be optimized for performance and dataset size.

Please share/add if you have more thoughts on this.
- We also got a dedicated server for Power BI gateway.

Frequent Visitor

i'm also getting the same error when using incremental refresh with an ODBC connector for google big query. Any updates would be great.

New Member

I have the same issue when I pull from multi source via web. Any idea that what's going on and whether you've resolved your case?

Not applicable

I'm facing the same issue. Any update, please?


Thank you,

Askale Med

I'm having the same issue

Advocate I
Advocate I

I am facing the same errors frequently as well.

Not applicable

Same for me. Are you guys still facing the same?

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Kudoed Authors