How do i connect Salesforce ApexAPI to Power BI using get data.

[roysampad91]

Postman Screenshot

What should be the URL and header params to be used on PBI

[roysampad91]

The issue hasn't been resolved any other ideas please?

[Anonymous]

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