Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a year in a table (SQL Server defined as Int). But when I imported into Power BI, it is taking as Whole Number as shown in the picture.
Solution 1:
So I changed DataTyep to 'Date' and as soon as I did it is converting Years as below:
2017 --> 7/9/1905
2018 --> 7/10/1905
2019 --> 7/11/1905
Solution 2:
as mentioned in other posts, I tried to add a column from Example, but still same outcome.
I also verified Options/Regioanl Setting and it is set to United States.
Thank you,
Kumar
Solved! Go to Solution.
I added a new column and derived date using
HI @Anonymous ,
I can't reproduce your issue, can you please share more details information to help us clarify and reproduce this?
For example:
Database version, client version, what connector used to get data...
In addition, if you use t-sql query in advanced option to get table records, did these date field receive succeed? If you change column type to text, did it display full date values?
Regards,
Xiaoxin Sheng
Thanks for the response,Xiaoxin. Please find attached link for data spreadsheet and pbix file.
HI @Anonymous ,
I can't use your link, it only redirect and display a authentication website for signin account.
Regards,
Xiaoxin Sheng
Thanks for looking into this ,Xiaoxin.
yes, I removed the link sharing as I found the solution.
I added a new column and derived date using
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |