Create calendar table with Azure Data Explorer (ADX) DirectQuery connection

[maneschr2022]

Hi,

I'm using ADX and I have connected my data with DirectQuery.

I'm using Power BI Desktop and the report is going to be in the Report Server. I think this type of connection doesn't allow me using DAX to create a Calendar table as the option is disabled. Is there another way to create a calendar table when using ADX DirectQuery connection?

[amitchandak · Accepted solution]

@maneschr2022 , if that is not supported you might have to create that source. Normal direct query connection allow table creation in dax