Dataflows > Power Query > Unexpected error

(0) Share

Report

Posted on by RoryJC

I've created a Dataflow to consolidate Excel files held in a SharePoint folder.

I did this in Dataflows > Power Query > SharePoint folder connector

When it comes to the final stage Do not load to table, then Refresh manually I get "We encountered an unexpected error."

I cannot use the WebAPI as an alternative as I get an Invalid Credentials error everytime I point it anything apart from an Excel file or SharePoint list.

Categories:

Dataflows

All responses (4)

Answers (0)

v-jefferni on at

Like (0)

Report

Re: Dataflows > Power Query > Unexpected error

Hi @RoryJC ,

So, below are the screenshots of security roles setup and user assignment:

If you have resolved the problem, please consider accept this as a solution to help other members find it.

Best regards,
Community Support Team _ Jeffer Ni
RoryJC 6 on at

Like (0)

Report

Re: Dataflows > Power Query > Unexpected error

I think we've figured out the permissions bit. I'm not a System Administrator on the environment. I was a customiser previously

I'm basically getting an Unexpected Error anytime I try to create a Dataflow.
RoryJC 6 on at

Like (0)

Report

Re: Dataflows > Power Query > Unexpected error

Thank yu @v-jefferni ,

The CIO is looking at the Access Control (IAM) blade but cannot see the right permission. I guess the system customizer security role is the most appropriate.

Could you give us some tips how to find that role and allocate it, please?

Thanks

Annotation 2020-1...
v-jefferni on at

Like (0)

Report

Re: Dataflows > Power Query > Unexpected error

Hi @RoryJC ,

I made a test in PowerQuery using SharePoint Folder connector and worked fine.

Since you mentioned in the end, and as per this post:
https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Unexpected-error-importing-data-with-power-query/m-p/521145, please make sure you have been assigned to a system administrator or system customizer security role.

Please take the check and try again.

If the issue persists, you may raise a ticket on support page with session ID:
https://powerapps.microsoft.com/en-us/support/

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.