I got a problem in power bi where my dates in the csv file is changed when I imported the csv file into power bi
You didn't say what your problem was exactly, but if you have dates with a timezone, you might want to do this:
Remove any "Changed Type" step.
Click on the date icon for the field and click the last option - Using Locale.
Change your dialog box to show date time zone and then pick your country.
After you have done that, you can change the type again to just a date, or datetime, or leave it datetimezone, your call, but this next step make sure you tell it to add a new step, not replace what you just did. In the right-hand Query Steps you will have two Change Types in sequence.
If that isn't the issue, then you need to tell us what the actual problem is.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
You didn't say what your problem was exactly, but if you have dates with a timezone, you might want to do this:
Remove any "Changed Type" step.
Click on the date icon for the field and click the last option - Using Locale.
Change your dialog box to show date time zone and then pick your country.
After you have done that, you can change the type again to just a date, or datetime, or leave it datetimezone, your call, but this next step make sure you tell it to add a new step, not replace what you just did. In the right-hand Query Steps you will have two Change Types in sequence.
If that isn't the issue, then you need to tell us what the actual problem is.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
