Global options

Global options only need to be set once and concern fundamental settings, including data source privacy levels and security:

1. Set the DirectQuery option to Allow unrestricted measures in DirectQuery mode
2. Configure the security options to require user approval for new native database queries and to use the ArcGIS Maps for Power BI
3. Set the privacy option to always combine data according to privacy level settings for each source
4. Configure the Power Query Editor options to display the Query Settings pane and the Formula Bar
5. Click the OK button in the bottom-right corner of the Options dialog to apply these settings:
   • It may be necessary to restart Power BI Desktop for the revised settings to take effect

For DirectQuery datasets, not all DAX functions can be translated to a SQL statement for execution by the data source. When DAX measures use these non-optimized functions, especially against larger or unfiltered tables, the local execution can result in poor performance. However, when used appropriately, such as against pre-filtered or aggregated data, unrestricted measure expressions can add to the analytical value of the dataset without negatively impacting performance. See the official documentation for DAX-formula compatibility with DirectQuery models http://bit.ly/2oK8QXB.