Different Sources for a single dashboard/visuals

Hi rkee10 ,

 

Is it possible to aggregate the data based on any dimension or date. For example, if its daily data, then make to Monthly. That way the number of rows would reduce while bringing from original source.

And also ensure only selected columns are taken from the source.

 

Thanks,

Pallavi

Hi All,
Firstly  pallavi_r thank you for your solutions！

And rkee10 ,According to your description, we can incrementally refresh the data source to help you dynamically get the values within two years without destroying the original report, avoiding the crash problem caused by loading a large amount of historical data, here is the document I found for you, I hope it will help you! 

We use the following picture for you to do a layman's explanation, when we configure a good incremental refresh, we can dynamically select the data interval we need according to the time, outside of this part of the data will not be read, which greatly reduces the amount of our data set, to improve the performance of the report to ensure that the data will not be crashed because of the over-sized.

 

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

 

 

 

 

 

Hi rkee10 ,

It's been a while since I've heard back from you and I wanted to follow up. Have you had a chance to try the solution that has been offered? If the issue has been resolved, could you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!