Global, and not on..." /> Global, and not only from Options --> Current Workbook.Read here abo..."> Global, and not only from Options --> Current Workbook.Read here about the rationale for this request: http://datachant.com/2017/01/11/10-common-mistakes-powerbi-powerquery-pitfall-2/" />
Skip to main content

    Power BI

    New

    Allow us to have a global option to disable the automatic detection of column types

    Vote (81) Share
    Gil Raviv's profile image

    Gil Raviv on 14 Jan 2017 00:08:58

    Please allow us to disable the feature "Automatically detect column types and headers for unstructured sources" from Options --> Global, and not only from Options --> Current Workbook.

    Read here about the rationale for this request: http://datachant.com/2017/01/11/10-common-mistakes-powerbi-powerquery-pitfall-2/

    Comments (4)
    Gil Raviv's profile image Profile Picture

    f030e6ba 0920-e911-a969-000d3a4f3343 on 16 Jul 2020 20:05:56

    RE: Allow us to have a global option to disable the automatic detection of column types

    This idea was implemented in Power BI Desktop July 2020.
    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2020-feature-summary/#_Global_option_to

    Gil Raviv's profile image Profile Picture

    7da7af1f 442d-4da1-b85b-fb29f8527054 on 05 Jul 2020 23:58:34

    RE: Allow us to have a global option to disable the automatic detection of column types

    In addition, could we please give users the option to enable/disable all things currently under the Current File section under the Global Settings section of Power BI Options? This is really annoying having to change things like “Automatically detect column types and add changed type”, “auto detect new relationships on data load” every time we create a new PBI Desktop file.
    Alternatively, could we please remove the “Current File” section of the options entirely and move all of the options under here under “Global” and have it apply to all PBIX files.

    Gil Raviv's profile image Profile Picture

    a2480f9d dd8b-4034-b344-95b10e9f8ddb on 05 Jul 2020 23:45:05

    RE: Allow us to have a global option to disable the automatic detection of column types

    '+1

    Gil Raviv's profile image Profile Picture

    a3deedfa 7846-431b-bed4-f9b93398850a on 05 Jul 2020 23:24:51

    RE: Allow us to have a global option to disable the automatic detection of column types

    '+1