DirectQuery

[Anonymous]

Hi,

I am buildinga report that is refreshes realtime and to do so, I need to use directquery. When I use the DirectQuery, and add transformation steps, I get an error that transformation is not allowed with directquery. 

I am wondetring if its possible to have realtime data refresh and have transformation steps. 

Thanks

Daven

[amitchandak]

@Anonymous , All Transformations steps are not possible, few simple calculations are possible.

refer

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#limited-data-transformations

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#limitations-of-directquery

Few possible, I covered here

https://www.youtube.com/watch?v=My0bLn9voo4&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA