Pivot Live Direct Query Data

[Rigoleto]

HI,

I built a dynamic table and pivoted it , just I am showing dates, Weekend, my questions is how can I do dynamic the dates that will being showing, basically Do I need to show is 3 weeks, current week, past week and priority week.

Is there a way to show tree weeks at the same time, dynamic?

and do a refresh of those date in an automatic way?

Thanks in advance

[v-yulgu-msft]

Hi @Rigoleto,

Since the data connection is under Direct Query mode, Pivot is not a supported tranformation. For details, please see Limited data transformations

Best regards,

Yuliana Gu