Direct Query Mode - SAP BW - Calendar Date

[Pierre08]

Hi All,

I am new to Power BI and to this forums as well, So pls go slow on me 🙂

Through Direct query mode I've extracted data using SAP BW Connector.

with limitation on Time Intelligence in Direct Query mode, how can i create "Weeknum" and "Start/End_Of_Week" in these mode.

Basically, i need "End of the week - Date" for visualiation to show no of transcations occured in week.

Thanks in advance.

 

[lbendlin]

Through Direct query mode I've extracted data using SAP BW Connector.

Not really. Direct Query means no extract is happening. Every time your users interact with your report this will trigger a new query against SAP BW. 

You can only add columns to a Direct Query data source if they are derived from values in the same row.