Forum Discussion
Can't get my validated datetable
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?
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.
2 Replies
v-weiyan1-msftCommunity Support
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
Super User
Are you using Import or DirectQuery? Also, are you using custom SQL or connecting directly to the table?
