Forum Discussion
Configuration for OAuth 2.0 Cloud Foundry with Power BI
In power BI setup , there is no OAuth2 authentication option
Hi TriptiSodales,
Thanks for the update.
In Power BI, the Web connector doesn’t show OAuth2 as a direct option. If your SAP Cloud Foundry login is linked with Azure AD or SAP IAS, you can try the “Organizational account” option.
Another way is to first get an OAuth2 access token outside Power BI for example, in Postman using your BTP app’s Client ID, Client Secret, and token URL. Then, in Power BI, go to Get Data → Web, choose Web API, and add the token in the header like:
Authorization: Bearer <your_token>
go through with the below document hope it may resolve your Issue:
https://learn.microsoft.com/en-us/power-platform/sap/connect/entra-id-apim-oauth
https://learn.microsoft.com/en-us/power-query/connectors/web/web
Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community support Team.
Hi TriptiSodales,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.Hi TriptiSodales,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.I used to follow this step
"in Power BI, go to Get Data → Web, choose Web API, and add the token in the header like:
Authorization: Bearer <your_token>"but its not works ..........so I write query to import data but below error occurs while connecting .
error is "DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: Data at the root level is invalid. Line 1, position 1.)
Details:
[Binary]"Can you help me to solve this error