Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Unexpected error while...
Customer experience | Sales, Customer Insights,...
Suggested answer

Unexpected error while trying to ingest data

(0) ShareShare
ReportReport
Posted on by Manjula Chintharla 25

Unexpected Error whilte trying to ingest data in trial environment in US region.

ApiResponseError: Unexpected Error
at d.handleLoadEvent (us.prod.powerquery.microsoft.com/.../o.a.91edce4d754dea383399.bundle.js:2:27477)
at XMLHttpRequest.<anonymous> (us.prod.powerquery.microsoft.com/.../o.a.91edce4d754dea383399.bundle.js:2:28523)

Add data source :: Microsoft Power Query

Data source : https://aka.ms/CI-ILT/Contacts

pastedimage1666678598879v1.png

  • Suggested answer
    rdj Profile Picture
    rdj 87 on at
    RE: Unexpected error while trying to ingest data

    Hi Mukesh Pohuja,

    The older trial still has the ingestion issue. However, the new Trial version works like it should. I consider this case closed for now, since I could work with the new trial environment.

  • rdj Profile Picture
    rdj 87 on at
    RE: Unexpected error while trying to ingest data

    Thanks Mukesh,

    Ticket has been created at MSFT.

    I already went that route as well (Dataflow created in Dataverse), but I got stuck in this view below even before being able to select the Dataflow I created.

    pastedimage1668157132540v1.png

  • Mukesh Pohuja Profile Picture
    Mukesh Pohuja on at
    RE: Unexpected error while trying to ingest data

    Is it the same error when you create a new dataflow (under Dataverse) from https://make.powerapps.com; do you already have a support ticket? it shouldn't make a difference if its trial or paid environment.

  • Badge Profile Picture
    Badge 30 on at
    RE: Unexpected error while trying to ingest data

    Hi,

    I managed to load this data using PowerQuery with file/csv. Here is my code..

    let
      Source = Csv.Document(Web.Contents("">aka.ms/.../Contacts"), [Delimiter = ",", Columns = 20, QuoteStyle = QuoteStyle.None]),
      #"Promoted headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true])
    in
      #"Promoted headers"
    pastedimage1668008245311v1.png
    Could it be a restriction of a trail instance?
  • rdj Profile Picture
    rdj 87 on at
    RE: Unexpected error while trying to ingest data

    It's just a simple Excel file containing not more than 100 records stored in OneDrive.

    The issue already starts from not being able to "browse OneDrive"

  • Bill Ryan Profile Picture
    Bill Ryan 803 on at
    RE: Unexpected error while trying to ingest data

    I have seen this before on trial instance with onedrive.  Is this a custom file? if so is there anything unique (very large, possibility of control characters, unique encoding etc)?  

  • rdj Profile Picture
    rdj 87 on at
    RE: Unexpected error while trying to ingest data

    Hi,

    I've experienced recently that CI has connection issue with OneDrive. 

    - new data source: [Unexpected error (Session ID: 9b6a5...3a0ca, Region: europe)]

    - existing data source: which was setup correctly with PQ connected to OneDrive. After clicking on the edit button, I was exposed to data type selection instead of bringing me directly to the PQ editor. And I could not proceed to the PQ Editor because it got stuck with the same "unexpected error" message

    Anyone else experience this?

  • Suggested answer
    Bill Ryan Profile Picture
    Bill Ryan 803 on at
    RE: Unexpected error while trying to ingest data

    This is a trial instance, right? I've seen that happening a few times recently. If you have a OneDrive, you can put it there and link directly.  I think referencing the link directly may help as well, filestransfer.blob.core.windows.net/.../Contact.txt

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans