Empty date fields defaulting to today's date

[Anonymous]

Hi All

I have some reports which pull from a sharepoint site. For projects which do not yet have a GA date, we leave this date field blank in the sharepoint site. However; when we pull this data into PowerBi, any blank date fields with default to today's date, which is obviously very misleading.

Is there a way I can get this to show up as NULL or blank?

Thanks

Alannah

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Anonymous ,

Everything works fine on my side.

Did you use DateTimeZone.ToLocal() type?

Please check if there are some transfrom operations. You could see all steps in Applied Steps:

In addition, please upgrade the Power BI Desktop to the latest version and have a try again.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

how are you pulling the data from sharepoint.  It seems strange that it just giving it a default today value in power bi, that value must be coming from sharepoint or someone must have changed it in the code, power bi wont assign values unless its present or you change it in the transform?  can you share your code  and can you see the data in sharepoint?

[Anonymous]

Hi Venessafvg,

The field in the sharepoint site look as per below. It is the CourseGA which is causing issue. The data is just connected via the Get data > Online Sharepoint list - and otherwise synching perfectly. Seems very strange!