Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Something went wrong while refreshing or saving existing dataflows

Hello!

 

I've got a problem with refreshing dataflows.

I did no changes since 30 of december.

I have only changed the password of my organizational account.

After that automatic refresh of my dataflows started to fail.

I recieve a massage: There was a problem refreshing your dataflow. {"RootActivityId":"6723826d-f082-470a-a1a3-6bc240fffc6f"}

If I export any my existing dataflow to JSON and import it in a new one - the new dataflow saves and refreshes normally.

But existing dataflows even can not be saved...

There is a technical information:

Something went wrong
Could not perform this operation due to an internal error
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: dbdc0ef1-696e-422c-b3a5-f39655fc65e9
Request ID: 1cf94b79-7e5f-b265-367a-ef812a8fe923
Correlation ID: 436aff84-3e39-8d51-c481-88e632a4044f
Status code: 500
Time: Fri Jan 10 2020 12:36:41 GMT+0300 (Москва, стандартное время)
Service version: 13.0.11747.315
Client version: 1912.2.031
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

 

I appreciate any help

1 ACCEPTED SOLUTION
Anonymous
Not applicable

The microsoft thech support fixe the issue.

Now I see more detailed logs.

And they wrote me this:

If you set up a separate schedule for the linked dataflow, dataflows can refresh unnecessarily and block you from editing the dataflow. There are two recommendations to avoid this issue:

  • Avoid setting a refresh schedule for a linked dataflow in the same workspace as the source dataflow
  • If you want to configure a refresh schedule separately, and want to avoid the locking behavior, separate the dataflow in a separate workspace.

View solution in original post

4 REPLIES 4
V-pazhen-msft
Community Support
Community Support

@Anonymous 

I am sorry that I cannot reproduce the error on my side. However,  I have some suggestions for you:

1. Checked the status of your gateway, is it online or offline.

2. Any other details about the refresh fail except the ids? 

refreshfaile.JPG

 


Best,
Paul

Anonymous
Not applicable

Hello! 

These dataflows don't use my gateway. However, it works and it is online.

When I try to refresh dataflow, I recieve error:

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
Invalid dateSNOW_2020Failed   FailedThere was a problem refreshing your dataflow. {"RootActivityId":"ea5b92d5-8238-a51d-64f0-88a7594e335d"}

By the way, earlier I have been recieveng another error:

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
01.10.2020 10:32SNOW_2020Failed   Failed

There was a problem refreshing your dataflow. {"RootActivityId":"6723826d-f082-470a-a1a3-6bc240fffc6f"}

 

 

Anonymous
Not applicable

The microsoft thech support fixe the issue.

Now I see more detailed logs.

And they wrote me this:

If you set up a separate schedule for the linked dataflow, dataflows can refresh unnecessarily and block you from editing the dataflow. There are two recommendations to avoid this issue:

  • Avoid setting a refresh schedule for a linked dataflow in the same workspace as the source dataflow
  • If you want to configure a refresh schedule separately, and want to avoid the locking behavior, separate the dataflow in a separate workspace.
Anonymous
Not applicable

Hello, Paul!

The gateway is not used in these dataflows. And our gateway is online anyway.

There is no more specific information, unfortunately.

 

When I try to refresh my dataflow, I now recieve message:

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
Invalid dateSNOW_2020Failed   FailedThere was a problem refreshing your dataflow. {"RootActivityId":"d8f7f04d-d38a-d1a1-21b4-7ea2a68111bc"}

Earlier, I have been recieving error message:

Run timeDataflow nameDataflow refresh statusEntity nameStart timeEnd timeEntity refresh statusError
01.10.2020 10:32SNOW_2020Failed   FailedThere was a problem refreshing your dataflow. {"RootActivityId":"6723826d-f082-470a-a1a3-6bc240fffc6f"}

As you can see, Run time column differs.

 

When I try to save edits to dataflows, I recieve message:

Something went wrong
Could not perform this operation due to an internal error
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 268c4698-9fa2-40e2-90bc-01a5870267f9
Request ID: 6a4b8d81-c333-1fdd-de86-a064375b2412
Correlation ID: 79321f91-48e3-67f0-83d0-283f78e4164c
Status code: 500
Time: Mon Jan 13 2020 11:13:31 GMT+0300 (Москва, стандартное время)
Service version: 13.0.11747.315
Client version: 1912.2.031
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

 

That is all I can tell about the problem.

What can I say else?

  • There is depending dataflow "SNOW", which uses entities from dataflows: "SNOW_2018", "SNOW_2019" and "SNOW_2020" and combines the similar data.
  • I have read about premium capacity restart, but I can't do this: I see only purchase offer on admin-portal page... This is strange, because I'm sure that I own premium capacity. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors