Data profiler skips or omits some columns

Hi Using Data Profiler version downloaded in Dec 2019- analyzing tables in microsoft dynamics DB, and profiler does not profile all the columns

Sometimes it skips almost half the columns in wide tables.  Is this expected?  Why does it skip some columns? thx

Parents
No Data
Reply
  • In the Profile Data Types selection options, Large objects are excluded by default. This includes varchar(max), nvarchar(max), text, ntext, varbinary(max), image and xml. If you want to profile all fields, select ALL Data Types including Large objects after Connecting to a SQL Server instance. These data types are excluded by default because they increase the time to profile. If you hover over the Profile Data Type option, a tooltip will appear that lists the data types for each option.

Children
No Data