Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Empty date fields defaulting to today's date

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 i...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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!