Call Power Automate HTTP Request Trigger in Power BI for data source

[jeremyt]

In Power Automate I have a HTTP Request Trigger automation set up that generates some data and returns the JSON.

When this Power Automate flow is set to 'Anyone' for "Who Can Trigger The Flow", I can successfully connect to this data source in Power BI through Web.Contents(...).

When I update my Power Automate flow to 'Any user in my tenant' for "Who Can Trigger The Flow", the the data source query in Power BI asks for credentials.

When I try the "Organizational account" option, I get the error "We were unable to connect because this credential type isn't supported for this resource. Please choose another credential type".

When I try 'Windows' or 'Basic' I get the error "We couldn't authenticate with the credentials provided. Please try again."

In what way should I be setting up Power BI to connect to this Power Automate flow?

[Anonymous]

Hi @jeremyt ,

Based on your description, the probability is that wrong or unreasonable voucher information is causing the problem. You can troubleshoot it in the following ways:

• Check permissions: Make sure the user account you are using has the required permissions to trigger the flow.
• Adjust data source settings: In Power BI, go to Data Source Settings and clear any existing credentials for the Power Automate stream. Then, try reconnecting using the appropriate authentication method.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jeremyt]

Thanks @Anonymous for the suggestions!

Clearing existing credentials didn't help, I still get the same results as above.

As for the "Check Permissions" suggestion, in Power Automate the flow is set to allow anyone in my tenant (which includes me). If there are any other permissions I need to check or set to allow this to work, can you point me to what I should be checking?