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.
I am trying to set a snowflake table as date table. I have confirmed that the date column that I am using as a key has a date datatype and has unique values. However when I try to mark it as Date table, the OK option is disabled. Note: Using direct query
What am I doing wrong?
Surprisingly I could convert the table to Date table after I moved it to Import mode.
Not sure if I can. Is there a restriction on marking tables as date tables that are running on DirectQuery mode?
Hi, @sthatte
DQ mode does not affect this function, I need more details to judge.
Do you connect to snowflake data through these steps?
Connect to Snowflake computing warehouse in Power BI Desktop - Power BI | Microsoft Docs
Can you add some more details?
Best Regards,
Community Support Team _ Janey
@sthatte , Have you already marked as key column, if yes revert that. make sure column Tools shows it as date and not Key icon in front on the date name.
After that, you try this again
Thanks for your reply but no luck 😞
@sthatte , is it possible to share pbix after removing sensitive data ?
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 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |