Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?!
Solved! Go to Solution.
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
Besides, PBI has no problem when reading the dates of any of the files I select at Combine File query editor window. The issue is comes when it combines different files
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |