Need to connect to API that requires OAuth2

Hi danielamengual 

You can try to refer to the following link to connect the api by OAuth2

powerbi - Private REST API connection Power BI (M - Power Query) - Stack Overflow

Chris Webb's BI Blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI (crossjoin.co.uk)

But it better to use custom connector ,because when you write it directly by M, the safety will be affected. the following link is about use custom connector.

Power Query SDK overview - Power Query | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.