Customer experience | Sales, Customer Insights,...

Unexpected error while trying to ingest data

(0) Share

Report

Posted on by Manjula Chintharla

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Bill Ryan 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
rdj on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Bill Ryan 8 on at

Like (0)

Report
Copy link

Link copied!

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)?

Was this reply helpful? Yes No
rdj on at

Like (0)

Report
Copy link

Link copied!

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"

Was this reply helpful? Yes No
Badge 30 on at

Like (0)

Report
Copy link

Link copied!

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"

Could it be a restriction of a trail instance?

Was this reply helpful? Yes No
Mukesh Pohuja Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
rdj on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

rdj on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No