Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sonal2901
Frequent Visitor

Can't mark table as date table

Hi,

I have a date table using sql query from oracle database. It is in direct query mode.
When I'm trying to mark it as a date table, and select Date Colum, it gets validated successfully but  the OK button is disabled.

I tried changing format from datetime to date but it didn't worked. 

Any help would be appreciated. Thanks

Sonal2901_0-1658833444946.png

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Sonal2901 , It should be a date column without any timestamp. And dates should not repeat. Make sure datatype is date or datetime

It is a date column with timestamp. I tried creating copy of this column removing timestamp in the oracle query but that isn't happening. Used trunc too but it sets the timestamp to midnight rather than removing it.

I can't change its datatype in Power BI because it will make my table to switch to import mode and I need it to be in dual mode. 😞

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.