Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Postman Screenshot
What should be the URL and header params to be used on PBI
The issue hasn't been resolved any other ideas please?
Hi @roysampad91 ,
You can refer the following links to get it:
Create a custom connector:
Solved: How to specify HTTP request header parameter in Po... - Microsoft Fabric Community
I see you're trying to get data from the Power BI API by writing your own M code in the Power Query Editor - this is not going to work unfortunately, because it is not possible to work with APIs that use OAuth2 authentication in this way. The only way to get data from an API that uses OAuth2 authentication is by creating a custom connector; there is a reasonably easy way to do this that I describe here https://blog.crossjoin.co.uk/2018/11/13/openapi-power-bi-rest-api-m/ and I think other people have blogged about this too.
Connect to Salesforce Objects connector:
Power Query Salesforce Objects connector - Power Query | Microsoft Learn
Best Regards
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.