I would like to have some clarification on what is really happening when one selects Private/Organizational/Public privacy levels on PowerBI. The official website states that "In Power BI Desktop, privacy levels specify an isolation level that defines the degree that one data source will be isolated from other data sources."
Let's say I have a PowerBI Desktop file with 3 Power Query queries, all of which come from different tables under the same Oracle schema:
- What are the differences of selecting any of the privacy levels?
- What is a data source in this context? Each independent Power Query query? My Oracle schema?
- What does it really mean "isolation" of a data source?
- Selecting Public Privacy Level... Does this may expose any data in the future (when the report is distributed) or only during the refresh process?
Today PowerBI released a really cool feature - Using R in Query Editor. But one must select Public Privacy Level in order to use it. I'm wondering... if PowerBI is mainly targeting enterprises, why does it require to use Public Privacy Levels for things like these?