Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

edhans

Inconsistent CSV Import when Data Detection Disabled

Submitted by Super User on ‎08-17-2020 06:32 PM

I have automatic data type detection disabled for unstructured data sources. Yet when I go to import a CSV file, this is how the UI looks:

edhans_0-1597714267845.png

  1. It should be set to "do not detect data type" (3rd choice in the drop down)
  2. If I have it set to detect based on first 200 rows, or entire data set, then it should, even if I have the overall option turned off. Either that, or these options should not be shown on this dialog box. Leaving it set as is it will not detect data types, which is misleading.

August 2020 desktop.

 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎08-18-2020 09:55 PM

@edhans 

 

You may share feedback via Ideas to help improve Power BI.

edhans
Super User
Super User
‎08-19-2020 08:58 AM

Hi @v-chuncz-msft - this seems to be a bug to me. If it says "Based on first 200 rows" should it not do that? Instead, the setting in options overrides, but doesn't indicate that. I'm not asking for a new feature, just that all places in Power BI desktop work consistently with the new "do not detect data type" option.

If you think this is not a bug, but is operating as designed, and should be an idea, please let me know.

Idea Statuses