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

romee — Mon, 24 Jul 2023 09:13:24 GMT

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-API-Reporting/m-p/2196697#M32991

and here: https://csod.my.site.com/supportcentral/s/article/How-do-we-integrate-Power-BI-with-the-Reporting-API?language=en_US

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!

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

Anonymous — Tue, 25 Jul 2023 07:07:17 GMT

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 Overflow

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

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

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

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