Forum Discussion

Lucy64's avatar
Lucy64
Advocate II
9 years ago

Creating a Date Table

I have connected to data in SQL Server using DirectQuery.  I need to create a date table within Power BI but it appears this is not supported with DirectQuery mode.  Is that correct or am I missing s...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Lucy64,

 

Currently, we are not able to create a calendar table when we connect to SQL Server database in DirectQuery mode, as the "New Table" feature is disabled. In your scenario, you need to create this calendar table on SQL Server database side.

 

Besides, you can vote on this similar idea: Create DAX measures, fields and tables in Direct Query mode.

 

Best Regards,
Qiuyun Yu