Search notes:
Power Query Editor: File -> Options & Settings -> Query Options
Global
Data Load
Type Detection: Choose one of
Always detect column types and headers for unstructured sources
Detect column types and headers for unstructured soruces according to each file's setting
Never detect column types and headers for unstructued sources
Default Query Load Settings
Use standard load settings
Specify custom default load settings (Load to worksheet or Load to Data Model)
Fast data Load
Data Cache management Options
Clear cache
Power Query Editor
Layout: Tick or untick
Display the Query Settings pane
Display the Formula Bar
Data Preview
Display preview contents using a monospaced font
Show whitespace and newline characters
Parameters
Always allow parameterization in data source and transformatino dialogs
Formula
Enalbe M Intellisense in the formula bar, advanced editor, and custom column dialog.
Security
Native Database Queries
Require use approval for new native database queries
Certificate Revocation Check
Enable certificate revocation check
Web Preview Warning Level
Strict
Moderate
None
Approved ADFS Authentication Services
Privacy
Privacy Levels
Always combine data according to your Privacy Level settings for each source
Combine data according to each file's Privacy Level settings
Always ignore Privacy level setting
Diagnostic Options
Diagnostic Options:
Enable tracing
Enable or disable Crash Dump Collection
See also
the
standard library function
Diagnostics.Trace
.
Current Workbook
Data Load
Type Detection
Detect column types and headers for unstructured sources
Relationships
Create relationships between tables when adding to the Data Model for the first time
Update relationships when refreshing queries loaded to the Data Model
Background Data
Allow data preview to download in the background
Regional Settings
Locale
Privacy
Privacy Levels
Combine data according to your Privacy Level settings for each source
Ignore the Privacy levels and potentially improve performance
Index