cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RoryJC
Regular Visitor

Dataflows > Power Query > Unexpected error

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.

4 REPLIES 4
v-jefferni
Community Support
Community Support

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-q..., 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.

RoryJC
Regular Visitor

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

RoryJC
Regular Visitor

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.

v-jefferni
Community Support
Community Support

Hi @RoryJC ,

 

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

63.png64.png65.png

 

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

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,309)