Forum Discussion
Date cells empty after importing from Sharepoint folder excel sheet
Hi!
I have a weird case that is driving me crazy
I receive a compressed excel file on my inbox daily. I open it and save it on a Sharepoint folder.
The format for all dates is the same for all files:
mm-dd-yyy
On Power BI desktop I have a table that feeds from that Sharepoint folder combining files:
The thing is that the date from the first file are ok, but the column for dates of the other files are empty!
My Region setting are set to English UK
I try to Change type using locale, but same result. Only the rows from the first file appears, the rest empty!
I cannot make it work!
Any ideas?!
- I managed to fix it. I think the issue was that I used to open the file first in excel in order to save it in SharePoint, even though the format was the same for all files it was somehow creating a conflict. Now I just extract the files in my desktop and upload it straight from there to SP. It worked.
4 Replies
v-piga-msftResident Rockstar
Hi Anonymous ,
By my test with the file in SharePoint folder, I cannot reproduce your issue.
Which connector do you use in power bi desktop? SharePoint folder or others?
What about setting your Region setting as mm-dd-yyyy and try again?
Best Regards,
Cherry
thanks Cherry,
I am using from Sharepoint Folder connector
The thing is that I have a lot of tables and files within are in dd-mm-yyyy format.
This is the only table with different date format.
I try changing my regional setting and same result.
Anyways, why does it works for the first file, but not for any other file in the same folder. That is what seem very weird to me