Forum Discussion
Gingerjeans88
Helper IV
Helper IVPivot 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 complex I will have to think of another way.
Hi Gingerjeans88 ,
Or you can pivot the columns with SQL.
Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs
2 Replies
v-xuding-msftCommunity Support
Hi Gingerjeans88 ,
Or you can pivot the columns with SQL.
Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs
- amitchandak
Super User
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
