Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transpose Table in DirectQuery

Hello everyone,

 

I have this data : 

 

I want to build a table in Power BI with transposed columns :

 

I have tried all solutions from this website but none of them works : we use DirectQuery which limits Power Query functionnality.

=> Is it possible to do it in Power BI or should I do it directly in the source (database) ?

 

Thank you.

Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi,

     

    When we connect Power BI desktop to a live data connection like Direct Query, the data is not imported in this case. Thus disabling us from doing any transformations like you have queryed about. You need to transform your data in above format as above, before loading it to Power BI in Direct Query mode.

     

    Thanks.

  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    It can only be done in power query,but such step doent support direct query mode,and it requires you to switch to import.Otherwise,it cant be realized.

     

    Best Regards,
    Kelly
     
    Did I answer your question? Mark my post as a solution!

3 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi,

     

    When we connect Power BI desktop to a live data connection like Direct Query, the data is not imported in this case. Thus disabling us from doing any transformations like you have queryed about. You need to transform your data in above format as above, before loading it to Power BI in Direct Query mode.

     

    Thanks.

  • VasTg's avatar
    VasTg
    Memorable Member
    6 years ago

    Anonymous 

     

    Did you try transpose in power query?

     

     

    Input as below

     

    If it helps, mark it as a solution
    Kudos are nice too

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ，

     

    It can only be done in power query,but such step doent support direct query mode,and it requires you to switch to import.Otherwise,it cant be realized.

     

    Best Regards,
    Kelly
     
    Did I answer your question? Mark my post as a solution!