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.
Hey everybody,
I'm using a DirectQuery to an Oracle Database, and I want to convert one of my columns from the Data Type: Text (at the moment the fields are strings in the format"6/09/2016"), to Date d/mm/yyyy. Using the formatting section of the Modeling tab will only work with an import, and I've tried following answers to similar questions using DAX with measures and custom columns but to no avail.
Is there a simple fix? or do I need to change they way I load the data into the database?
Any help will be greatly appreciated,
Thanks
Ronan
Solved! Go to Solution.
@Anonymous
In Power BI Desktop, the Direct Query mode only takes the source data type, and you can't change the data type under this mode. So in this scenario, you have to convert the text column into date column on Oracle side.
update Table set Date_Date = to_date(Date_Text, 'D/MM/YYYY');
Regards,
@Anonymous
In Power BI Desktop, the Direct Query mode only takes the source data type, and you can't change the data type under this mode. So in this scenario, you have to convert the text column into date column on Oracle side.
update Table set Date_Date = to_date(Date_Text, 'D/MM/YYYY');
Regards,
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |