Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Anyone knows how to perform the OAuth2.0 Authentication using the Power Query for TD Ameritrade.
I am able to make API call using the Power Query, but i need to manually enter the 30min access token.
Trrying to creat a power Query request to perfom the OAuth2.0. Once received the 30min Access token, use it as a function to perfom API requestes.
Solved! Go to Solution.
Got the solution from this video:
https://www.youtube.com/watch?v=2RZkc_qrV1g&t=6s&ab_channel=BIElite
Got the solution from this video:
https://www.youtube.com/watch?v=2RZkc_qrV1g&t=6s&ab_channel=BIElite
Hi @victorF ,
If want to connect from Power BI to a REST API that uses OAuth2 authentication then you need to build a custom connector. You can find documentation on how to implement an OAuth2 flow in a custom connector here.
Refer this blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @v-yingjl
I have been trying to build the custom connector, its quite compluicated as i am not so familar with M code.
I have the cURL for the POST request. Sucessfully tested in Postman.
Postman alows to convert the cURL in many languages but not in to M code.
Are you aware of any tool to convert any code language in to M code?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
11 | |
9 | |
7 | |
6 |