Handle a report with Data refresh monthly dataset vs weekly refresh dataset in my SSAS Cube model?

Anonymous — Fri, 28 May 2021 01:27:57 GMT

Hello Developers,

I have a situation where my pbix report has all the datasets are coming from one source table, to which the data refresh frequency is monthly likewise the report gets refreshed on a monthly basis. Now, there is a new table that has got coulmns acts as new dataset that is required in my report. The data refresh frequency for the new table is weekly.

Now, the quesiton, how can i handle in my report with two different data refresh frequencies ? The real challenege behind this would be some of the visuals sourced from monthly data refresh might not align with visuals that has got sourced from weekly refresh.

Note: model is SSAS cube using direct query mode.

@Meg @Fen @Anonymous @MFelix @amitchandak, @lbendlin

Re: Handle a report with Data refresh monthly dataset vs weekly refresh dataset in my SSAS Cube mode

lbendlin — Fri, 28 May 2021 11:33:47 GMT

Your question is ambiguously worded. Please try again.

You can refresh individual partitions via XMLA scripts.

topic Handle a report with Data refresh monthly dataset vs weekly refresh dataset in my SSAS Cube model? in Developer

Handle a report with Data refresh monthly dataset vs weekly refresh dataset in my SSAS Cube model?

Re: Handle a report with Data refresh monthly dataset vs weekly refresh dataset in my SSAS Cube mode