Load to Common Data Service failed. Details: Index was outside the bounds of the array

[Christian]

Hi,

Was creating  a Dataflow and testing it multiple times with different columns.

All of a sudden I get this error:

"Load to Common Data Service failed. Details: Index was outside the bounds of the array.. (Job ID: 32d3874e-0a58-430c-8d0c-0473c9b93e6f)"

I have tried stripping the dataflow and even creating a new dataflow with only two columns. Now I just keep receiving the above error.

Any ideas why this is happening?

[v-monli-msft · Accepted solution]

Hi @Christian ,

Are you reusing an existing query?

If so, you may have follow the steps in below thread and see if the issue could be resolved.

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Work-around-for-a-bug-when-importin...

Regards,

Mona

[Christian]

Thanks for helping.

I am not sure where to edit those settings - I tried looking all over the Dynamics and PowerApps settings but cannot find it anywhere.

[Christian]

I finally solved the issue with the help from the suggestions you gave me.

To resolve the issue i went to https://admin.powerapps.com/dataintegration and deleted everything under projects, Connection Sets and Templates.

This somehow cleared the cache and i can now create a new Dataflow and run it successfully.