Transform Data from SharePoint List

avocados12345 · ‎03-14-2018

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 · ‎03-15-2018

@avocados12345,

You may check the link below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avocados12345 · ‎03-15-2018

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