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
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'.
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
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
Please check the settings of the Dataflow. What I can find is the credential error.
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
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?
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.
The issue relates to refreshing. Can you still create a new one?
How does it look like in the settings of the Dataflow?
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
Find out who's part of the program this season, and welcome the new Super Users.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.
Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.