Direct Query Mode - SAP BW - Calendar Date

Pierre08 — Thu, 23 Mar 2023 20:10:47 GMT

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.

Re: Direct Query Mode - SAP BW - Calendar Date

lbendlin — Mon, 27 Mar 2023 00:56:00 GMT

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.

topic Direct Query Mode - SAP BW - Calendar Date in DAX Commands and Tips

Direct Query Mode - SAP BW - Calendar Date

Re: Direct Query Mode - SAP BW - Calendar Date