Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Start Date - null values

Hi, 

This is so bizzare. I really don't know what is wrong. 
I have linked my data via sharepoint. All files are in the same format, column and file names, etc. 
One of the recent June files just doesn't want to pick up the dates: 'Start Date' column. It is showing null. 
No errors, no nothing, just blank. 
Any ideas? 
I have re-inserted the file, re-checked, re-everything, I think. 
I have creted a special table to show errors, but PowerBi didn't find any errors.

Any suggestions are welcome. 

Best, 

J

Need Help
Show and Tell
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    >> One of the recent June files just doesn't want to pick up the dates: 'Start Date' column. It is showing null. 

    Are you connecting to a SharePoint folder? Which table has this issue(null Start Date)? Could you share the capture of it? And please find the difference between files with blank start Date and others with non-empty start Date.

     

     

    Best Regards,

    Community Support Team _Tang

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

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    >> One of the recent June files just doesn't want to pick up the dates: 'Start Date' column. It is showing null. 

    Are you connecting to a SharePoint folder? Which table has this issue(null Start Date)? Could you share the capture of it? And please find the difference between files with blank start Date and others with non-empty start Date.

     

     

    Best Regards,

    Community Support Team _Tang

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