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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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

Top Solution Authors
Top Kudoed Authors