Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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.
User | Count |
---|---|
68 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |