Forum Discussion
Solved
Pivot Columns with DirectQuery?
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 compl...
Hi Gingerjeans88 ,
Or you can pivot the columns with SQL.
Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs
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