I am trying to use AWS Security Hub APIs within a PowerBI project. I have had no luck getting calls to it working. I contacted AWS Security Hub Report about this, and they recommended I try using the bare endpoint URL of securityhub.us-east-1.amazonaws.com. I used this URL for a new Web Source and Basic Connection, to which I recieved an error saying 'Unable to connect to the remote server' (screenshot of this attached). AWS Support said that this implies the issue lies with PowerBI somewhere. Do you have any recommendations or guidelines for invoking AWS Security Hub APIs in PowerBI? Is there anything in particular that I should try?
I guess there could be a firewall and strict rules. I would suggest you collect a diagnostic trace in Options>Diagnostics>Collect diagnostic information. Take a closer look at the error section for useful information.