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

Dataflows not refreshing

I have a few dataflows set up which use API sources via Basic Auth. They were working fine 2 days ago but stopped this morning. I have checked and they load correctly in the query editor (in dataflows) and call the API but if I refresh them via the menu or schedule they simply do not start. I have downloaded the errors and it just says all entities failed to refresh.

 

Error: Internal error Request ID: 4ffed8b7-9429-cbd4-8056-b24b5852bcef Activity ID: 312445a0-1b37-4414-8210-3e9868b5686f

 

UPDATE: I have now added a flow which uses just an Azure SQL Table with the same result (can see the data in the editor but does not refresh on-demand or scheduled:

 

Error: Internal error Request ID: a924e5c9-2910-0f2c-fe7b-2d6af9f77596 Activity ID: 7a5c5f49-77ea-4e66-8953-298cc1af96fe

19 REPLIES 19
Highlighted
Microsoft
Microsoft

Re: Dataflows not refreshing

Hi @GS-OIT,

 

Can you share the complete error message, please? I tried to find it in the log database and I did find something. It seems you need to use a new authentication method. I would suggest you contact your administrator.

>>>AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access 'f3b07414-****************41f3f4128'.

 

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 I
Helper I

Re: Dataflows not refreshing

The API based issues have the following error output.  I have the same code running successfully within a PBI dataset on the same group.

 

Run Time: Invalid date

Dataflow: ####### - Lookup Tables

Status: Failed

Entity: Boards

Start: 30/11/2018 17:05

End: 30/11/2018 17:05

Failed Error: Internal error Request ID: fc4ee9e1-0593-e23d-1f65-19117de875f6

Activity ID: f6056529-bf86-4f11-ba28-88a01d419e2e

Highlighted
Microsoft
Microsoft

Re: Dataflows not refreshing

Hi @GS-OIT,

 

Please check the settings of the Dataflow. What I can find is the credential error. 

Dataflows-not-refreshing1

 

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 I
Helper I

Re: Dataflows not refreshing

This seems odd, I have a dataset that requires no connection and is purely generated by M code.  This is now coming back with a refresh error.  Could the authentication be something to do with Dataflows and Power BI validation rather than with the data source?

 

Start: 03/12/2018 08:52

End: 03/12/2018 08:52

Error: Internal error Request ID: 1ca7786b-7651-9957-31ff-87f107bfdaa9

Activity ID: f6b2450d-49d3-49bf-9677-9f9a93f46d51

 

Highlighted
Microsoft
Microsoft

Re: Dataflows not refreshing

Hi @GS-OIT,

 

I would suggest you create a new one from scratch. I only found this error. Please check it out or contact the administrator.

>>>Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access 'f3b0741*************41f3f4128'.

BTW, did the error have something like below?

Dataflows-not-refreshing2

 

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 I
Helper I

Re: Dataflows not refreshing

It doesn't give me this information because in the Dataflows it just gives you a download of the errors which don't include the cluster information.  It does look like there's something to do with me having multi-factor authentication on my Azure AD and a restriction somewhere in an admin config that is stopping these dataflows refreshing ... but it's not clear from the errors or the message you have shared as to how I can resolve it. 

 

I created another one from scratch with the same issue.

 

I really apprecaite your help on this, I think dataflows are going to be awesome and they were working for a few days and then just stopped, I will take a look through our admin logs and see if I can see any changes.

Highlighted
Helper I
Helper I

Re: Dataflows not refreshing

How do I find out what the ID relates to that it's trying to use multi-factor authentication on?

Highlighted
Microsoft
Microsoft

Re: 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

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 I
Helper I

Re: Dataflows not refreshing

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 ADimage.pngimage.pngimage.png

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