Power BI

Completed

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

Vote (81)

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/

Administrator on 08 Dec 2020 00:37:25

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

Comments (4)

Comments (4)

Gil Raviv 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

Eric Marshall 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.

Lisa on 05 Jul 2020 23:45:05

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

'+1

Power BI User on 05 Jul 2020 23:24:51

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

'+1