Pivot Columns with DirectQuery?

[Gingerjeans88]

Just checking I am not wrong here - you can't Pivot columns when using DirectQuery mode? 

Is there a generic sub-query I can alter for a workaround? I am clueless with SQL so if this is at all complex I will have to think of another way. 

[v-xuding-msft · Accepted solution]

Hi @Gingerjeans88 ,

Or you can pivot the columns with SQL.

Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs

[amitchandak]

@Gingerjeans88 , No you can not. For that, you need to convert the table to import mode.  But pivot means a new column, you should be able to create a measure with some filters. If you do not need too many