I'm trying to fetch data using api. In doing so, I'm selecting Get Data -> Web, and providing the URL, Authorization as Key and Basic xyzxyz(the actual key) as value of the header. However I keep getting DataSource.Error "We are unable to retrieve the contents of the web page."
I'm able to get the results in JSON when I use curl or Postman to make a request. Seeking some help on using Power BI to fetch the data so that I can create vizualizations.