Refresh error on server - multi datasource

[Anonymous]

hello , need your help

a report with different data sources

a first request queries a database to retrieve a value which in a second request will call an API

it works fine on the dekstop version, but as soon as I put it on the power bi server it doesn't work and when I refresh it I get the error

[Unable to combine data] Section1/Page views/Type modified1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

here's the API call, the variable retrieved from the DB is accessToken

Source = Json.Document(
Web.Contents(
"https://api.linkedin.com",
[
RelativePath = "v2/organizationalEntityShareStatistics?q=organizationalEntity&organizationalEntity=urn:li:organization:XXXXXXXXXXXXXXX&timeIntervals.timeGranularityType=DAY&timeIntervals.timeRange.start="&StartEPOCH&"&timeIntervals.timeRange.end="&EndEPOCH,

Headers=[
#"Authorization" = "Bearer " & #"accessToken"
]
]
)
)

[lbendlin]

Happy Reading!

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn