Can't get my validated datetable

[Manon]

Hi all,

I'm having some issues with my datetable.

Through Snowflake database connection I load my date dimmension table from my database.

When I'm trying to make that table an official datetable, It validates my column, but I can't press the 'OK' button.

I also validated the table myself. It has continuous dates, no blanks, no doubles.
Anyone an idea?

[v-weiyan1-msft · Accepted solution]

Hi @Manon ,

Based on your description, you have validated the data table as described below.

Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn

Please try to keep your version of Power BI Desktop up-to-date to avoid problems caused by the version.
In addition, the following link had the similar problem as yours. Please kindly refer to it and see if it helps you.

Solved: Not able to click OK in 'Mark as date table' dialo... - Microsoft Fabric Community

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DataInsights]

@Manon,

Are you using Import or DirectQuery? Also, are you using custom SQL or connecting directly to the table?