Global options only need to be set once and concern fundamental settings, including data source privacy levels and security:
- Set the DirectQuery option to Allow unrestricted measures in DirectQuery mode
- Configure the security options to require user approval for new native database queries and to use the ArcGIS Maps for Power BI
- Set the privacy option to always combine data according to privacy level settings for each source
- Configure the Power Query Editor options to display the Query Settings pane and the Formula Bar
- 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.