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.
Hello,
I have the following issue: i am using the desktop version and connecting to a sybase database.
In the database the date values are stored as text fields like: '20171003'
I convert this value to date values.
This value should return in dutch culture 03-10-2017 for 3 october 2017.
This works well in the desktop version but after publishing the report and refreshing it by the on premis gateway the datevalues are shown incorrect. I get the result 10-03-2017 instead.
I hope someone has a sollution.
Thanx
@Arnoh wrote:
Hello,
I have the following issue: i am using the desktop version and connecting to a sybase database.
In the database the date values are stored as text fields like: '20171003'
I convert this value to date values.
This value should return in dutch culture 03-10-2017 for 3 october 2017.
This works well in the desktop version but after publishing the report and refreshing it by the on premis gateway the datevalues are shown incorrect. I get the result 10-03-2017 instead.
I hope someone has a sollution.
Thanx
Have you format the date in Power BI desktop? I'm not able to reproduce that issue.
Hi thanx for your reaction,
Yes i formated the date in the desktop.
I have some screen shots addes.
In the snapshot, I see FAC_DATUM shows as the expected "DD-MM-YY" which is different from the description in your original post.
In the last snapshot you see in the kolom factuur datum dates with value 10-02-17.
In the sybase database these value is stored as ‘20171002’ as text.
In the Powerbi Desktop the date returns as 02-10-17 which is should be (dd-mm-yy).
After publishing the values seems to be ok and are also shown as 02-10-17.
When the data is refreshed the values show 10-02-17.
Only dates where month an day are able to switch are shown incorrect.
So date 23-02-2017 (23 february 2017) will go correct after refreshing.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |