Write
462
edits
Difference between revisions of "Privacy Level settings in Microsoft Excel"
Jump to navigation
Jump to search
m
Privacy Level settings in Microsoft Excel (view source)
Revision as of 21:19, 19 March 2025
, 19 Marchchanged order of ignore and select privacy levels
m |
m (changed order of ignore and select privacy levels) |
||
| 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 are not concerned about isolation of data sources, you can choose to ignore Privacy Level settings | |||
= Ignore Privacy Levels Settings = | |||
# Navigate to Data > Get Data > Query Options. | |||
* If you have ''multiple OdataLink solutions'' and want to quickly disable privacy levels: | |||
# Navigate to '''Privacy''' Settings under '''Global''' settings. | |||
# Select the '''Always ignore Privacy Level Settings''' and click OK. | |||
* To ignore Privacy Level only for the ''current workbook'': | |||
# Navigate to '''Privacy''' Settings under '''Current Workbook''' settings. | |||
# Select the '''Ignore the Privacy Levels and potentially improve performance''' and click OK. | |||
= Setting Privacy Level for a Data Source = | = Setting Privacy Level for a Data Source = | ||
| Line 23: | Line 32: | ||
* '''''Organisational''' level has been observed to be the most optimal level in most cases.'' | * '''''Organisational''' level has been observed to be the most optimal level in most cases.'' | ||
== Related Topics == | == Related Topics == | ||