web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Determine columns with...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

Determine columns without data in DataVerse

(1) Share

Report

Report

Posted on by graflunds

We will be syncing data from Dynamics 365 to an Azure Data Warehouse, and I got a request from management to find out what columns in tables we will be syncing over have no data.

Our environment is very heavily customized.

I have access to SSMS environment and the DataVerse that way, but INFORMATION_SCHEMA is not available there.

Anybody have any code or a trick to figure out what columns in a given table, or a list of tables, are blank?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Partner,

Could you tell me what app you are using in D365?

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Pallavi Phade 102 Super User 2026 Season 1

#2

ManoVerse 58 Super User 2026 Season 1

#3

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans