Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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" |
Solved! Go to 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.
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/
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
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.