Forum Discussion

colmcag's avatar
colmcag
New Member
3 years ago
Solved

API request 405 Method not Allowed Error

Hi,   I am getting a 405 error when trying to connect to Open FIGI:     The request is similar to the below postman query:     This is what I've tried in PowerQuery (I've also tri...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi colmcag 

     

    I don't have this problem in my Excel. It works well too. Did you select Anonymous for the data source like below? If not, go to Home > Data source settings and clear all permissions. Then select Anonymous for it. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

colmcag's avatar
colmcag
New Member
3 years ago

thanks v-jingzhang .

 

Interestingly this works fine when I use Power Query in PowerBI.

However, when I use Power Query in Excel, it gives the following error:

 

DataSource.Eror: Web.Contents with the Content Option is only supported when connecting anonymously.

It allowed me to edit settings > ok

And then we are back to the same 405 error again.

 

Any idea why this happens in excel?

 

Thanks,

Colm

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi colmcag 

 

I don't have this problem in my Excel. It works well too. Did you select Anonymous for the data source like below? If not, go to Home > Data source settings and clear all permissions. Then select Anonymous for it. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.