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, ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial