API connections in two steps no longer working

[Anonymous]

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]...

[lbendlin]

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.

[Anonymous]

@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.

[Anonymous]

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. 

[seba]

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

[lbendlin]

Have you updated to the latest version of report server?

[seba]

Yes, I did. Running May 2021 now.