Forum Discussion
Filter semantic model on import to only include recent data
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!
2 Replies
- amitchandak
Super User
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
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!
