Transpose Table in DirectQuery

[Anonymous]

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.

[Pragati11 · Accepted solution]

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 · Accepted solution]

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!

[VasTg]

@Anonymous 

Did you try transpose in power query?

Input as below

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

[Pragati11 · Accepted solution]

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.