Forum Discussion

minaxi's avatar
minaxi
Frequent Visitor
8 years ago

Couldnt authenticate web content(REST API)

   Hi,   We have created salesforce REST API that is querying the objects using SOQL and then passes it in JSON format.   I am now trying to use the URL in power bi desktop and its giving me an...
Need Help
Show and Tell
Tips and Tricks
metrica's avatar
metrica
Icon for Post Prodigy rankPost Prodigy
2 months ago

Hi minaxi,

 

Salesforce REST APIs normally require OAuth and a Bearer access token. Basic authentication is not supported for standard Salesforce REST APIs.

 

If the endpoint mainly queries Salesforce objects through SOQL, you may evaluate Power BI Connector for Salesforce:

https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

 

It provides Power BI with an OData endpoint. Custom Apex logic may still require your existing API.

 

Documentation:
https://metricasoftware.com/docs/salesforce/

 

Cheers,
Metrica Team