Hello,
I am new with PowerBI and not sure if this is even possible.
I have a main table/data model which I appended multiple months of data (different tables per month, which I append tables per month). A column on the data model had originally a Date and Time format which I changed the format to Date only (this is the only format I used for a couple of months now). I then unchecked the "Enable Load" on the previous months which I did not realize that there would come a time that I would need to have the time along with the date to measure the time interval.
Steps I have tried to retrieve the data :
1. I have tried to change the format to Date and time in the data model but it only gives me 12:00:00 on all rows.
2. I have checked the "Enable Load" then refresh power query and the main page, but it is still showing 12:00:00
3. I tried deleting the steps of "change type" on the applied steps on the power query, but no good.
I am new with PowerBI and not sure if this is even possible.
I have a main table/data model which I appended multiple months of data (different tables per month, which I append tables per month). A column on the data model had originally a Date and Time format which I changed the format to Date only (this is the only format I used for a couple of months now). I then unchecked the "Enable Load" on the previous months which I did not realize that there would come a time that I would need to have the time along with the date to measure the time interval.
Steps I have tried to retrieve the data :
1. I have tried to change the format to Date and time in the data model but it only gives me 12:00:00 on all rows.
2. I have checked the "Enable Load" then refresh power query and the main page, but it is still showing 12:00:00
3. I tried deleting the steps of "change type" on the applied steps on the power query, but no good.
