How to calculate changes in data cubes on a weekly bases

[Anonymous]

Hello,

I have created two similar tables (same datasource) from which I calculate on weekly bases what are the changes from week to week. Therefor I use AFO' s as source. I have to update this manually every week and do some extra handling before updating the PBI desk top.

I want to do this directly from SAP business warehouse message server so I can update this automaticly  every week. So that I see every monday the changes versus last week.

Does anyone has an idea ?

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, you can use the function automatic page refresh in Power BI Desktop which is only available for DirectQuery sources and some LiveConnect scenarios.

Automatic page refresh in Power BI enables your active report page to query for new data, at a predefined cadence like below.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Community Support Team_yanjiang

[Anonymous]

Sorry for my late reply but I was on a short vacation.

I managed to built the report from DirectQuery and used the Auto Page refresh every 7 days. But I think it will overwrite the old data and I want to calculate the differences between last week and current week