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

[kxj54590]

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 

[lbendlin]

Your question is ambiguously worded. Please try again.

You can refresh individual partitions via XMLA scripts.