Forum Discussion

Aamir2021's avatar
Aamir2021
Copper Contributor
Jul 28, 2021

Getting error in power query

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

 

microsoft 365
  • shekharb's avatar
    shekharb
    Copper Contributor
    Jul 28, 2021
    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.
    • Aamir2021's avatar
      Aamir2021
      Copper Contributor
      Jul 28, 2021
      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

Resources