Privacy Level settings in Microsoft Excel: Difference between revisions
mNo edit summary Tag: Manual revert |
m added category levels Troubleshooting > Privacy Tag: Manual revert |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 14: | Line 14: | ||
* [[Data Refresh Error: Cannot convert the value "Record" to type Record|Cannot convert the value "Record" to type Record]] | * [[Data Refresh Error: Cannot convert the value "Record" to type Record|Cannot convert the value "Record" to type Record]] | ||
If you use only Odata feeds as a data source and are not concerned about isolation of data sources, you can choose to ignore Privacy Level settings. | If you use only Odata feeds as a data source and are not concerned about isolation of data sources, you can choose to ignore Privacy Level settings. It is also possible to configure the privacy level for each individual data source. | ||
= Ignore Privacy Levels Settings = | = Ignore Privacy Levels Settings = | ||
To ignore Privacy Level only for the '''''current workbook''''': | To ignore Privacy Level only for the '''''current workbook''''': | ||
# Navigate to Data > Get Data > Query Options. | # Navigate to Data > Get Data > Query Options. | ||
# Under '''Current Workbook''' settings, Navigate to '''Privacy''' Settings. | # Under '''Current Workbook''' settings, Navigate to '''Privacy''' Settings. | ||
| Line 24: | Line 27: | ||
If you have '''''multiple OdataLink solutions''''' and want to quickly disable privacy levels for '''''All workbooks''''': | If you have '''''multiple OdataLink solutions''''' and want to quickly disable privacy levels for '''''All workbooks''''': | ||
# Navigate to Data > Get Data > Query Options. | # Navigate to Data > Get Data > Query Options. | ||
# Under '''Global''' settings, Navigate to '''Privacy''' Settings. | # Under '''Global''' settings, Navigate to '''Privacy''' Settings. | ||
# Select the '''Always ignore Privacy Level Settings''' and click OK. | # Select the '''Always ignore Privacy Level Settings''' and click OK. | ||
= Setting Privacy Level for a Data Source = | |||
If you use '''Other data sources''' and pass sensitive data to '''public or external private''' data sources, we suggest understanding Privacy Levels and then setting the privacy profile for each source. | If you use '''Other data sources''' and pass sensitive data to '''public or external private''' data sources, we suggest understanding Privacy Levels and then setting the privacy profile for each source. | ||
# Navigate to Data > Get Data > Data Source Settings. | |||
# Click and highlight the intended data source. | |||
# Click on '''Edit Permissions''' button. | |||
# Set the Privacy Level to your desired level. | |||
#: '''''Organisational''' level has been observed to be the most optimal level in most cases.'' | |||
= Understanding Privacy Levels = | = Understanding Privacy Levels = | ||
| Line 42: | Line 55: | ||
| Line 55: | Line 62: | ||
[https://odatalink.com/faq/what-are-the-privacy-levels-for-in-power-query-power-bi-and-excel Understanding Privacy Level settings] | [https://odatalink.com/faq/what-are-the-privacy-levels-for-in-power-query-power-bi-and-excel Understanding Privacy Level settings] | ||
[[Category:Troubleshooting | [[Category:Troubleshooting|Privacy]] | ||