Forum Discussion

SimonSays's avatar
SimonSays
Regular Visitor
6 years ago
Solved

AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together

I'm trying to combine a table from Microsoft Common Data Service with an API from Microsoft Cognitive Services. This works fine in Desktop but when I publish to Power BI Web Service and try refreshin...
Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago
    Hi there

    Could I ask why you cannot change the privacy levels?
SimonSays's avatar
SimonSays
Regular Visitor
6 years ago

Hi GilbertQ, thanks for your reponse. I tried Private, Public and Organizational privay levels for both queries but nothing worked.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Did you try NONE?
  • SimonSays's avatar
    SimonSays
    Regular Visitor
    6 years ago

    I did yes. None of the privacy settings allowed me to refresh the dataset once published to Power BI Web Service.

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      6 years ago
      That is something not normal, I have never had an issue once trying to refresh in the Power BI Service.

      It could only be with the different data sources.

      And you have configured the Gateway to refresh from the cloud & on-prem data sources?
      • SimonSays's avatar
        SimonSays
        Regular Visitor
        6 years ago

        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.