Getting error in power query

Copper Contributor

Hi All,

I am trying to load data in power query of office 365. But I get error when I click on load and close. I am attaching an error screen shot for your reference.

It would be great if you could suggest me where I am making mistake in power query.

 

Thank you

 

2 Replies
Hi Amir,
As per error it looks like credentials you are using to access the data does not have sufficient permission. Can you please check if you have permission. As per error it looks like source is recognizing the credentials.
Hi
Thank you very much for your response on this. However I am able to extract, transform and load data by using my API Key. But when I try to load by using Json mode then I face this error and over again.

Thank you again !
Aamir