Forum Discussion
Transpose multiple rows in to multiple columns in directquery
Anonymous
oh wow,
well yes, directquery wont work with power query pivoting table , it will ask you to use import mode instead.
what about pivoting the table in the backend , with sql , or oracle or any language you are using in the backend
or another approach maybe useful for you and easier in the backend.
you can still use the matrix visual
and for the naming of the questions, you can create a new column callled, mapped questions name.
and for the requirement of that you dont want to show all questions, you can in the filter pane --> filter on the visual, choose the questions that you want to show .
does this help you solve your problem ?
Hi Daniel29195,
Thanks for responding when I am pivoting it is asking me to import. But I am using direct query as the table is huge more than 600GB
Community ChampionAnonymous
oh wow,
well yes, directquery wont work with power query pivoting table , it will ask you to use import mode instead.
what about pivoting the table in the backend , with sql , or oracle or any language you are using in the backend
or another approach maybe useful for you and easier in the backend.
you can still use the matrix visual
and for the naming of the questions, you can create a new column callled, mapped questions name.
and for the requirement of that you dont want to show all questions, you can in the filter pane --> filter on the visual, choose the questions that you want to show .
does this help you solve your problem ?