Dear community,
I needs some help as I can't seem to solve an issue I have with date format.
I've create a Power BI report with a table visual. I want to export this (filtered) data to Excel using Power Automate. I managed to do so, however I need the dates as displayed in the Power BI table visual.
When the PA flow has ran and I open the Excel, I get the date minus 1 hour. The problem is (the most current example) the date shows 4-11-2022 in the table visual and in the Excel exort is shows 3-11-2022 23:00. This is the PA flow:
I know Power BI uses the PC regional setting but it seems like it uses standard UTC and does minus 1 hour because of the my local time.
I've doen several things to try and get the date from the visual, such as:
- Changing regional settings (in Power BI options);
- Changing data type to 'Date' instead of 'Date/time' in report page;
- Changing data type in Power Query;
- Splitting the column into date and time seperately.
Nothing seems to work. When I try exporting the table visual manually from Power BI service, I get the date I want without the time. It seems that the 'Run a query against a dataset' automatically convert the date to the ISO-8601 format (I found this in the PA flow log). I can't find anywhere online how to prevent this from happening.
Does anyone have an idea and/or solution for this? It would help me big time.
Kind regards.
