cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shoba_ravi
New Member

Running into Unexpected Error in Dataflow

Hi

I am trying to load data into an entity from Azure SQL Database using Dataflows in Power Apps

I am able to connect to the database, choose the table to export, transform data, define primary keys, define refresh settings. But when I click 'Create' it runs into an unexpected error.

I have System Administrator role assigned.

I have tried to create the dataflow in a Solution and directly too. Both ways run into the same error.

Error screen shot attached.

 

Error message:

section Section1;
shared AlertList = let
Source = Sql.Database("sqls-iop-dev-001.database.windows.net", "sqldb-iopconfig-dev-001"),
Navigation = Source{[Schema = "dbo", Item = "AlertList"]}[Data]
in
Navigation;

 
 
 
3 REPLIES 3
rohsh354
Community Support
Community Support

Hello,

 

What are the permissions and security roles assigned on the (target) CDS environment? Are you system administrator on CDS environment as well?

 

I assume that you are able to connect to Azure SQL database using same credentials outside of dataflows (like SQL Server Management Studio). 

 

You can try running a F12 network trace, and check if there are more information logged before you get that error message.

https://docs.microsoft.com/en-us/azure/azure-portal/capture-browser-trace

 

If it's not giving enough information, then I would suggest opening a Support ticket with Microsoft Support.

 

https://docs.microsoft.com/en-us/power-platform/admin/get-help-support

 

 

Hello Mr. Rohit Sharma

 

Thank you for your response. 

 

I have System Administrator role assigned to my CDS Environment. Screen print attached.

 

Yes, I am able to connect to Azure SQL database using same credentials using dataflows and outside of dataflows also.

 

I encounter the error when I am configuring up the refresh setting for the dataflow.

I have performed the network trace and the logs are attached

 

Let me know if you need any further information. Any help will be appreciated.

 

Regards

Shoba

 

Hello,

 

This is what I can see in your traces:

 

o.a.c672fbd0a5df1608ca3a.bundle.js:2 Uncaught (in promise) ApiResponseError: Unhandled HTTP Request Exception. Status Code: 400. Reason: undefined. Response Text: "Failed to get the dataflow entity details".
at new t (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.c672fbd0a5df1608ca3a.bundle.js...)
at e.value (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.c672fbd0a5df1608ca3a.bundle.js...)
at XMLHttpRequest.<anonymous> (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.c672fbd0a5df1608ca3a.bundle.js...)

 

If you have system administrator role on the CDS entity and able to connect to the SQL database as well fine, then it cannot be related to the permissions, but something else.

 

Since, its not clear from the traces, I would suggest opening a ticket with Microsoft Support to dig deeper and find out the reason for this failure.

 

https://docs.microsoft.com/en-us/power-platform/admin/get-help-support

https://powerapps.microsoft.com/en-us/support/

 

 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,544)