Forum Discussion

gb12's avatar
gb12
New Member
3 years ago
Solved

How to configure Power BI Desktop options?

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    3 years ago

    3. On the DirectQuery tab, enable the Allow unrestricted measures in DirectQuery mode setting. This enables additional DAX functions to be used in metrics against DirectQuery data models that are necessary to meet many common requirements.

     

    Although all DAX functions are supported for DirectQuery models, certain functions are not optimized for DirectQuery; they may not generate an efficient SQL query and may require local, single-threaded resources to execute.

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

6. On the Data Load tab for the CURRENT FILE, disable the automatic detection of column types and relationships. These model design decisions should be implemented explicitly by the Power BI developer with knowledge of the
source data.