Dataflows not refreshing

Hi GS-OIT,

The issue relates to refreshing. Can you still create a new one?

How does it look like in the settings of the Dataflow?

Best Regards,
Dale

I did this and it still didn't work. I have since change a new Azure AD policy which was recently applied. This makes it compulsory to have 2FA applied to administrator accounts. I removed myself from the policy and it is currently working.

I am going to try it for the rest of the day (checking it still works) and then re-apply the policy and see what happens as it does not take effect immediately.

I tried this because the message was also displayed following settings being applied to this area of Azure AD

Hi GS-OIT,

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

Best Regards,
Dale

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.

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.

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.

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

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?

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

Hi GS-OIT,

I would suggest you create a support ticket here.

Best Regards,

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.

---

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