Dataflow Gen2: Data source connection error (API)

[Kenny_Coker]

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. 

[Ekurt]

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:

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

[Pieter_NL]

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

[Expiscornovus]

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? 

[v-cboorla-msft]

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.

[v-cboorla-msft]

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.

[v-cboorla-msft]

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]

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?

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.

[Kenny_Coker]

Thanks @Expiscornovus 

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

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;

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