topic API connections in two steps no longer working in Report Server

API connections in two steps no longer working

Anonymous — Thu, 25 Mar 2021 10:57:26 GMT

Hi,

I've several reports that connect to third party sources using private API's - as they have daily exports of the current data, I wrote queries to connect to the API to get the list of exports, then take that answer and put it in to another version of the same API, giving me the information from the correct export.

All of them have stopped working with the Jan 2021 update of report server - they will refresh correctly in the desktop but scheduled refreshes fail with the generic error:

 COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, The given data source kind is not supported. Data source kind: UnknownCallsite..

One of the reports is still refreshing but when I copy that query into a new blank report, that fails it's test scheduled refresh with the same error.

Does anyone know why this is or if there is a work around?

My queries all work roughly the same way (I have put the second call in a calculated column/function, as well)

let
Source = Json.Document(Web.Contents("[API LINK]/[source identifier]/exports?api_token=[TOKEN]&api_token_secret=[SECRET]")),
Source1 = Source{1},
#"Converted to Table" = Record.ToTable(Source1),
Value1 = #"Converted to Table"{11}[Value], //this value is the api link for the latest export
Source2 = Csv.Document(Web.Contents(Value1 & "?api_token=[TOKEN]" & "&api_token_secret=[SECRET]"),[Delimiter=","]),
#"Promoted Headers" = Table.PromoteHeaders(Source2, [PromoteAllScalars=true]),

...[REST OF QUERY]...

Re: API connections in two steps no longer working

Anonymous — Mon, 29 Mar 2021 02:17:25 GMT

Anonymous
Please the veryfy the below restrictions for the datasources.

Datasets - Update Datasources In Group (Power BI Power BI REST APIs) | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: API connections in two steps no longer working

Anonymous — Tue, 20 Apr 2021 08:18:35 GMT

Hi Anonymous, thanks for the help but I'm not using the PowerBI API, it's not about sending requests to the PBI service. I'm using a third party's API as a source of data in the PowerBI desktop app.

Re: API connections in two steps no longer working

seba — Thu, 22 Jul 2021 02:06:39 GMT

Anonymouswere you able to solve your problem? I am experiencing the same issue.

Re: API connections in two steps no longer working

lbendlin — Wed, 23 Jun 2021 10:55:30 GMT

Have you updated to the latest version of report server?

Re: API connections in two steps no longer working

seba — Wed, 23 Jun 2021 11:05:19 GMT

Yes, I did. Running May 2021 now.

Re: API connections in two steps no longer working

lbendlin — Wed, 23 Jun 2021 11:56:10 GMT

Is the second link (Value1) an extension of the primary link ([API LINK]) (ie is it the same base URL) or does it go to a differently structured URL?

If the former try using RelativePath.