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"
]
]
)
)
