Forum Discussion
Data missing after service refresh
Thank you for your support. Today I've found out what was problem, or at least I think so. The column date was already set as format date in power query editor. I think there was a problem with the format before this changed type, which is dd-MMM-yyyy, with the month in letters (JAN-FEB-MAR...).
After adding a step te replace each month abbreviation with its number (01,02,03..) the problem seems solved
Thank you for your support. Today I've found out what was problem, or at least I think so. The column date was already set as format date in power query editor. I think there was a problem with the format before this changed type, which is dd-MMM-yyyy, with the month in letters (JAN-FEB-MAR...).
After adding a step te replace each month abbreviation with its number (01,02,03..) the problem seems solved
Hi,user-2024
Thank you for your response. I'm glad to see that you found a solution on your own. You can mark your own solution as Solution, which will help other users in the community with similar problems to yours to find the answer quickly!
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.