Best choice for Null type in Data Factory to Data Lake

[Anonymous]

Hey guys,

I'm setting up my integrations, bringing data in through Azure Data Factory to Data Lake and then into Power BI.

I've tried importing nulls as "\N" and as just "null", but both import as text.  Is there a specific version of Null that I should attempt to bring into my CSV to actually auto-create as a null column rather than the text null?

I'm okay with replacing "null" with null, but if there is a quick automated way of handling it, I can make that the default for my Data Factory pipeline.

Thanks,

Andrew

[v-qiuyu-msft]

Hi @Anonymous,

On Power BI side, there is no such null data type. "null" value imported to Power BI will be considered as the TEXT data type automatically.

If you have question about Null type in Data Factory to Data Lake, I would suggest you post question in Azure forums.

Best Regards,
Qiuyun Yu