Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

jocallier

Dataflow failed

Submitted by on ‎07-11-2022 01:41 PM

Hi !

 

One of our dataflow is failing to refresh since a couple of days. I'm used to get errors related to data issue but this time it seems that the message is very different and I can't find the issue and how to fix it.

 

This is the message I got. All the tables in my dataflow are showing the same error :

 

An error occurred while communicating with another service, please try again later. If this problem recurs, please contact support with this message. (Request ID: b413be07-c18b-4864-b377-5d41d58329f0)

 

Any ideas or suggestions ?

 

Thanks !

 

Status: Investigating

About optimizing dataflows in Power BI Service, you can refer:

  1. Dataflow refresh guidance 
  2. How we optimize Power Query and Power BI Dataflows 
  3. How to keep your Power BI dataflows organized and optimized 

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
3 Comments (3 New)
Comments
v-yingjl
Community Support
Community Support
‎07-11-2022 07:36 PM
Status changed to: Needs Info

Whether this dataflow could be refreshed at other time ranges that you can check it in your side to adjust the refresh time.

 

Or if try to create a new dataflow with the same data source and data size in a new workspace, whether it could be refreshed successfully.

 

If both not works, please consider providing more details about this issue, like the data source type, workspace type, some screenshots etc.

 

Best Regards,
Community Support Team _ Yingjie Li

jocallier
New Member
‎07-12-2022 03:45 AM

Hi @v-yingjl 

 

Thanks for the quick reply.

I have been able to export the problematic dataflow in JSON and recreate a new one from this export. I have also been able to refresh the new one wihtout issue.

 

But for some reason, this morning the automatic refresh of the problematic dataflow worked correctly after it failed for 4 days in a row...

 

The data sources hasn't changed and I haven't really changed anything in the dataflow settings yesterday...

 

I'm not sure why it worked today and I'm a little concerned this might happened again in the future for no reasons just like it did.

 

The dataflow has 49 tables. I'm using power bi pro only so there's no incremental refresh.

The total size of the data sources (all csv files) is about 500MB.

 

Is there any advice that you might have that would help me either better understand what the problem could have been or optimize the datablow so I can prevent the issue from happening again ?

 

Thanks again !

Jo

v-yingjl
Community Support
Community Support
‎07-12-2022 05:41 PM
Status changed to: Investigating

About optimizing dataflows in Power BI Service, you can refer:

  1. Dataflow refresh guidance 
  2. How we optimize Power Query and Power BI Dataflows 
  3. How to keep your Power BI dataflows organized and optimized 

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses