Forum Discussion
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...
- Hi there
Could I ask why you cannot change the privacy levels?
I did yes. None of the privacy settings allowed me to refresh the dataset once published to Power BI Web Service.
GilbertQ
Super User
Super UserThat 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?
It could only be with the different data sources.
And you have configured the Gateway to refresh from the cloud & on-prem data sources?
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.
- GilbertQThat is great that you found out the issue! Thanks for letting us know.