Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Gingerjeans88 ,
Or you can pivot the columns with SQL.
Using PIVOT and UNPIVOT - SQL Server | Microsoft Docs
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
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |