Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Kenny_Coker
Regular Visitor

Dataflow Gen2: Data source connection error (API)

 

mslearn-fabric (microsoftlearning.github.io)

I have Data Source connection issues while trying to create Dataflow(Gen2) via Synapse Data Engineering using the guidelines in the link above. The import tabs (Excel, SQL, Text/CSV, dataflows) give the error message below. 

"Something went wrong while loading required resources. Please try refreshing the page or come back later to try again. (APIs: connections In Scope)."

 

Much more, both import from Excel and Text/CSV tab generated "Unexpected error" page restricting further access to the import pages. Please see error message below.

 

---------- Message ----------

Unhandled HTTP Request Exception. Status Code: 400. Reason: undefined. Response Text: "ExternalServiceError".

 

---------- Stack ----------

ApiResponseError: Unhandled HTTP Request Exception. Status Code: 400. Reason: undefined. Response Text: "ExternalServiceError".

    at p.handleLoadEvent (https://uk.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.c2dedd539a7896950b5f.bundle.js:2...)

    at XMLHttpRequest.<anonymous> (https://uk.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.c2dedd539a7896950b5f.bundle.js:2...)

 

---------- Session ID ----------

e58577fb-a25f-4462-9228-a9742e974b16

 

---------- Request ID ----------

f52b4c18-1052-464d-93eb-7b381f53fe01

 

Please advise how to resolve this issue. 

8 REPLIES 8
Ekurt
New Member

I had the same error message, my main cause was that I had disabled the setting for Dataflow Gen1. Somehow, when it is disabled, no data connection works anymore:

Ekurt_0-1718114647397.png

You can only change this setting in the Admin Portal in Microsoft Fabric.

Pieter_NL
Frequent Visitor

I have this exact same issue, can't use a gen2 dataflow. Error like this on every datasource.

Expiscornovus
Continued Contributor
Continued Contributor

Hi @Kenny_Coker,

 

Hmm, strange that it already errors out. Have you tried to access this interface via an in-private browsing session in your browser? Just to see if that makes a difference? 

Hi @Kenny_Coker 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
If the issue still persists, please do let us know. Glad to help.


Thanks.

Hi @Kenny_Coker 

 

Following up to see whether your issue got resolved or still facing the issue. In case if you have any resolution please do share that same with the community as it can be helpful to others.

If the issue still persists. 

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

 

Thank you.

Hi @Kenny_Coker 

 

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

 

Thanks.

Expiscornovus
Continued Contributor
Continued Contributor

Hi @Kenny_Coker,

 

Just to double check, you tried importing that orders.csv of that lab and that failed in your Dataflow Gen2 setup?

 

Have you only tried the link to file option with the below file? 

https://raw.githubusercontent.com/MicrosoftLearning/dp-data/main/orders.csv

 

You could also download that file and upload file option instead in the connection settings?

 

getfiledata.png

 

 

Btw, I have just tested the link to file option with this specific file and I was unable to reproduce your issue, the file should still be anonymously accessible.

ordersfile.png

Thanks @Expiscornovus 

 

The moment i click on 'Import from Text/CSV' on the Power Query Editor , it gives the error message as seen below.

 

PowerQuery Page2.png

And this happened for both Import with Excel and Text/CSV file. The Import with SQL Server and Dataflow provides me with an interface to work with- just like it is in your screenshot. 

 

But common to all the import tabs (Excel, SQL, Text/CSV, Dataflows) is the pattern of error message higlighted in red below;

PowerQuery Page1.png

But this screen appears for a split-second for Import with Excel & Text/CSV, before the previous screenshot (Unexpected error) covers the page. 

Helpful resources

Announcements
Oct Fabric Update Carousel

Fabric Monthly Update - October 2024

Check out the October 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.