Transform Data from SharePoint List

[avocados12345]

Hello all,

Intriguing problem here. I can successfully connect to a SharePoint list using my organizational login. After connecting, I load all the data from the list with success. However, when I go to Edit Queries and attempt to unpivot columns, I get the classic Access to this resource is forbidden. message.

I'm have permission to edit the list in SharePoint in the browser, as well as in SharePoint Designer. 

Has anyone else encountered this issue and resolved? 

Thanks in advance

[v-chuncz-msft]

@avocados12345,

You may check the link below.

https://community.powerbi.com/t5/Desktop/SharePoint-List-Access-to-resource-is-forbidden/m-p/51475

[avocados12345]

Appreciate the glance at my issue, but I do not have difficulty connecting the list or viewing the data. It is when I attempt to transform that I receive the message. If that is mentioned in the link you provided, can you point it out?

Many thanks