cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sp_powerbi
Frequent Visitor

Frequent issues with Dataset refreshes across different workspaces in power bi

Hello,

 

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.

 

7 REPLIES 7
sp_powerbi
Frequent Visitor

Hello,

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.

jamiecarpenter
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.

peter_hue
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?

Anonymous
Not applicable

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

 

Thank you,

Askale Med

I'm having the same issue

yy_powerbi
Advocate I
Advocate I

I am facing the same errors frequently as well.

Anonymous
Not applicable

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.