cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Re: Dataflows not refreshing

Hi @GS-OIT,

 

I'm glad you found the cause. I'll appreciate it if you can share the final results.

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Dataflows not refreshing

I have the same error.

 

Error: Internal error Request ID: 42b2d3af-94a5-83df-86f2-b4d7224dbb5f Activity ID: 858536c7-a769-4a96-bfe2-6f1786e434eb

 

I also have 2FA enabled but unfortunately I can not disable it.

Highlighted
Helper I
Helper I

Re: Dataflows not refreshing

jason435,

 

Just to be clear, it was a policy where it was 'enforced' within Azure AD.  I changed it from being enforced for me but still had my 2FA enabled.  I have since reverted that setting and the issue has not re-occurred ... so either:

 

a) it resolved itself naturally (due to the authentication mentioned above being resolved)

b) the act of removing the enforcement and putting it back on solved the problem

c) changes that I am not aware of or that have been released since have resolved the problem.

 

Currently all dataflows are working still but I am not sure whether it was a co-incidence me changing settings or whether it changed anything.

 

Sorry, I cannot offer more insight but maybe worth checking the setting I mention in the Azure AD policy if you are an Administrator.

Highlighted
Helper II
Helper II

Re: Dataflows not refreshing

Thank you for the update. I wonder if that is the cause, I have other datasources, in datasets, using the same authentications method, and they work fine.

 

My dataflows are coming from excel files saved in onedrive for business. When I edit the entity, the preview refreshes no problem. If I edit the source, the data shown in query editor updates with refresh. However when I save and exit the editor, I can not refresh.

 

They were updating fine until early december they stoped. I wish the error message gave a little more insight.

 

 

Highlighted
Helper I
Helper I

Re: Dataflows not refreshing

After this working consistently since my last post, this morning it has suddenly failed again.  I have carried out the same actions (and I will see if it has any effect (over time).  Ironically it seems to be 14 days since the last issue, which fits in with the 2FA authentication issue.

 

@v-jiascu-msft Is there any way you can check to see what exactly is not being authenticated because I don't believe it's anything within the datasource, I believe there to be an authentication issue within the dataflow architecture which stops the refresh.  It stops within 3 seconds (for the whole job) and works fine if you go into it in the browser.

 

Most Recent Log:  

Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: 04e03947-a54c-48fc-906b-e53b58030501
Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: 28cf8040-79f4-4168-967f-1925a56f6b0f
Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: f1d1f306-a83b-4ec0-b1c8-8f039b6ff38a
Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: 80c2337f-8ae6-4ca6-8e6d-b95a9e6f3a58
Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: 095eef04-76b6-4f0a-8418-912bc9bb1808
Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: a597b472-3dd3-48b0-82f8-2362aed81536
Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: ffb32a05-60a8-4014-8f26-8f4f72a653ce
Error: Internal error Request ID: d0b77587-b2d4-f757-f93a-c9c2df579859 Activity ID: 9bf5edb7-a942-48e4-b0d1-087906f716dc

Highlighted
Helper I
Helper I

Re: Dataflows not refreshing

This is still an intermittent issue and I cannot figure out why it keeps failing (even with datasources that are purely M generated).  Any ideas?

Highlighted
Helper I
Helper I

Re: Dataflows not refreshing

Is there any further wisdom on this? I have checked and each time I open up the dataflow it works fine.  If I try to refresh it just shows this error with no detail.

 

I would love to transfer our business over to get the benefit from this but it just doesn't work at the moment.  As has been mentioned it might be authentication but it's not part of the credentials stored in the service as those work.  There must be some authentication between the Power BI service and one of the dependent items (i.e. Data Lake?  Processing? )

 

Error: Internal error Request ID: 8e87479c-5245-5589-27ba-c396319c03aa Activity ID: f431330d-28a9-43b7-a601-40ce20f6e5c4 Error: Internal error Request ID: 8e87479c-5245-5589-27ba-c396319c03aa Activity ID: e4bbe5aa-9e0b-4130-a0f0-44f67ffedca8 Error: Internal error Request ID: 8e87479c-5245-5589-27ba-c396319c03aa Activity ID: f6048c67-48b6-48fd-9a0a-be6154d86c2c Error: Internal error Request ID: 8e87479c-5245-5589-27ba-c396319c03aa Activity ID: d70fcec3-ad9d-41d7-8aa0-885ff7250dd5

Highlighted
Microsoft
Microsoft

Re: Dataflows not refreshing

Hi @GS-OIT,

 

I would suggest you create a support ticket here.

create-ATicket

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Dataflows not refreshing

Has this been resolved? We have been experiencing this very issues sine late Dec 2018. It is still a problem asof today.  I have confirmed that the identity used, mine, IS NOT enabled for MFA.

Highlighted
Helper I
Helper I

Re: Dataflows not refreshing


@sspeake wrote:

Has this been resolved? We have been experiencing this very issues sine late Dec 2018. It is still a problem asof today.  I have confirmed that the identity used, mine, IS NOT enabled for MFA.


This seemed to resolve itself about a month ago (without intervention) but it is unclear what has changed.

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors