Forum Discussion

Kenny_Coker's avatar
Kenny_Coker
Regular Visitor
2 years ago

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 im...
Data Engineering
Expiscornovus's avatar
Expiscornovus
Most Valuable Professional
2 years ago

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's avatar
    Kenny_Coker
    Regular Visitor
    2 years ago

    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.