Forum Discussion
Cannot 'Mark as date table'
Hi, I created a date table in my mysql database. The primary key is a column of (mysql) type date. Then I opened PowerBI desktop and added this table and I wanted to mark it as date table. The v...
I found the solution by myself:
It is mandatory to set the 'Data Connectivity mode' to Import and not DirectMode.
I'm having similar issues in that a date table I imported keeps giving me the message: The date column can't have gaps in dates
There are not any gaps in the dates. Based upon this thread, is there a glitch in this 'Mark as a date table' ability? I haven't seen a response since January
Thank you