How to solve errors when scheduling a refresh using the Reporting API from Cornerstone on Demand

[romee]

I have managed to successfully set up a connection between Cornerstone on Demand and PowerBI as described here: https://community.fabric.microsoft.com/t5/Developer/Setting-up-an-Odata-connection-for-Cornerstone-A...

and here: https://csod.my.site.com/supportcentral/s/article/How-do-we-integrate-Power-BI-with-the-Reporting-AP...

After publishing my report I wanted to schedule a daily refresh in PowerBI Services. However, I keep receiving the following errors: 

Following the documentation on how to connect I must choose anonymous as authentication method and none as the privacy level. 

Can someone tell me how I can succesfully schedule refreshes for my reports that are built using data from the Reporting API from Cornerstone on Demand? 

Thanks in advance!

[Anonymous]

Hi @romee ,

According to the error message, one possible reason for the GET failure is that the bearer token may have expired or the REST endpoint did not return a JSON response. Another possible reason is that the credentials provided for the Web source are invalid or the data source is rejecting the request. You can refer the solution in the following links which have the similar problem as yours to solve it:

Use an Azure Functions Proxy:

Power BI: Using anonymous authentication on Web data sources with a API key in URL – Kloud Blog

Update the credentials:

microsoft powerbi - Getting 400 Bad Request using Power BI Connector with Aprimo API - Super User

I reached out to Aprimo support and was given the following support.

From Power BI: 1. Click ‘Edit Queries’ 2. Home > Data Source Settings > Global Permissions 3. Select problematic connection > Edit Permissions > Edit > Basic > Input Report ID and Token > OK > Close

---

excel - PowerBI DataSource.Error: Web.Contents failed to get contents (400): Bad request - Stack Ove...

let
    Source = Json.Document(Web.Contents("http://3.93.175.1/api/abfrage/", [Headers=[Authorization="Token 6bcc8706f68d3635f1514ce22611e83c12b1e4c1", #"Content-Type"="application/json"], Content=Json.FromValue([number_of_requests="1", search_term="Transalb"])]))
in
    Source

Accessing REST APIs with Basic Auth and API Key in Power Query | John Dalesandro

Source = Json.Document(Web.Contents(PARAM_API_BASE_URL, [RelativePath = "/project/testprj", Headers = [Authorization = "Basic " & Binary.ToText(Text.ToBinary(PARAM_API_USERNAME & ":" & PARAM_API_USER_PASSWORD), BinaryEncoding.Base64), #"APIKey" = PARAM_API_KEY]]))

Best Regards