Filter semantic model on import to only include recent data

[mrlins]

Sorry for asking what I suspect is a very basic question! I am trying to learn 🙂

I have access to a semantic model dataset which contains data from several years but I only want the most recent 24 months. I understand that I can filter my visuals to only show that period, but I was hoping that there is some way I can filter on import so that only the data I need is imported and the report gets 'lighter'. Since I am not the owner of the dataset, I have no way of editing it but perhaps there is some other way?

Hoping that someone can help!

[mrlins]

@amitchandak Thank you very much for taking the time to answer, even if it wasn't the answer I was hoping for 🙂 I will have to continue experimenting with it and see!

[amitchandak]

@mrlins , If you are not the owner of the dataset/semantic model. I doubt that. We can use Power Query, M parameter filter to reduce that. Very similar to what we do in incremental etl.

Another alternative is to put a report(all pages), and filter in the report to reduce the data

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE