sending API requests from Power Query

[misaki]

When sending API requests from Power Query:
If I use the Web connector and store credentials in the credential store, I am unable to include a Content body in the Web.Contents request.
It appears that Power BI blocks requests that contain Content when credentials are managed by the credential store.

My question is:
How can I safely keep the credentials protected while still being able to send an API request that contains a Content body?

Is there a recommended or supported way to securely authenticate and include Content in Web.Contents requests?

[v-lgarikapat]

Hi @misaki 

Thanks for reaching out to the Fabric Community.

To better understand your scenario, could you kindly provide more details on the following points:

• What type of content are you trying to send in the request body?
• Are there specific authentication methods supported by the API (like OAuth or API keys)?
• What is the expected structure of your data that needs to be sent?

Thanks,

Lakshmi.