Forum Discussion
AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together
- Hi there
Could I ask why you cannot change the privacy levels?
Hi GilbertQ, I'm not using any on-prem data souces. I have a data set from a Microsoft Comon Data Services entity and I'm using a Microsoft Cognitive Services API to analyse the text in my Cds dataset. It's really a very simple setup and the queries are all in my original post.
Hi GilbertQ, I had overlooked the privacy settings in the BI Web Service and was making changes in desktop before publishing. I seem to have fixed the problem by changing both queries to Organizational privacy directly in the Web Service. Thank you for your help. I'll mark your reply as accepted solution.
- GilbertQ
Super User
That is great that you found out the issue! Thanks for letting us know. 
Hey SimonSays
Rigth now I'm having a similar issue.
I’m calling a text cognitive service (keyPhrases) through a custom function, here is the code:
let Origen = (text) => let jsontext = Text.FromBinary(Json.FromValue(Text.Start(Text.Trim(text), 10000))), jsonbody = “{ documents: [ { language: “”es””, id: “”0″”, text: ” & jsontext & ” } ] }”, bytesbody = Text.ToBinary(jsonbody), headers = [#”Ocp-Apim-Subscription-Key” = APIKey], bytesresp = Web.Contents(EndPoint, [Headers=headers, Content=bytesbody]), jsonresp = Json.Document(bytesresp) in jsonresp in OrigenIt’s work fine in PBI Desktop, but when I deploy it to PBI Service I got this error in the data source credential:
Web.Contents failed to get contents from ‘https://tapbi01.cognitiveservices.azure.com/text/analytics/v2.1/keyPhrases’ (404): Resource Not Found
I tried your solution, but now I get this error:Web.Contents with the Content option is only supported when connecting anonymously.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table:I restored it back to connect anonymously and again:
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"[Unable to combine data] Section1/MyTable/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination."}}],"exceptionCulprit":1}}} Table: MyTableI'd appreciate any help.