References other queries or steps, so it may not directly access a data source.

[jeronimo2334]

Hello, 

I have a report that utilizes a private API. It all works well when developing in the Desktop platform but when I publish to the service and try to sync the data I get:

• Underlying error code-2147467259
• Underlying error message[Unable to combine data] Section1/table_here references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
• DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
• Microsoft.Data.Mashup.MashupSecurityException.DataSources[{"kind":"Web","path":"API_URL_HERE"}]
• Microsoft.Data.Mashup.MashupSecurityException.ReasonPrivacyError

I have tried the solutions already mentioned in https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ but no luck. Also I have tried setting the privacy to `Private` and `None`. 

Quick description of how I have this setup. 
I have a Query that does this :

let
URL = "...",
AuthSource = "...",
AuthBody = [...],
AuthData = Json.Document(Web.Contents(AuthSource, [Headers=[#"Content-Type"="application/x-www-form-urlencoded"],
Content=Text.ToBinary(Uri.BuildQueryString(AuthBody))])),
Token = "Bearer "&Record.Field(AuthData, "access_token")
in
Token

Then I have another query like this 

let
Token = #"Token",
URL = "...",
Report = Json.Document(Web.Contents(URL,[Headers=[#"Content-Type"="application/json", Authorization=Token]])),
Embedded = Record.Field(Report, "return"),
#"Converted to Table" = ...
in
#"Changed Type1"

[GilbertQ]

Hi @jeronimo2334 

This is because of the firewall settings.

What you can do is follow this blog post below to see how to overcome this issue: https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

[Element115]

You shoud be more specific and write instead: It is because of the Data Privacy Firewall built into PQ! 

https://learn.microsoft.com/en-us/power-query/dataprivacyfirewall

[jeronimo2334 · Accepted solution]

I was able to figure it out. It looks like I had to set the privacy level to `Organizational` on both the Dekstop version and the service level.