title: Restrict data loaded from SSAS into Power BI
body: <p>I am connecting to Analysis Services from Power BI and choosing the import option I choose the dimensions and measures I want to add to the data model.</p>
  <p>This brings in all the data from the cube whereas I want to bring in only 2021 and 2022 data i.e. restrict the value of year dimension. I can filter the data once it is loaded but that means I will be bringing in a lot of data that is not relevant to the report.</p>
  <p>I do not want to load 10 years of data from the Cube when I will only need 2 years of data. How can I load only the data I need from SSAS (SQL Server Analysis Services) into Power BI?</p>
  <p>P.S: I can write an MDX query with a where clause, but I do not know how to write one. Using OLAP Pivot table extensions gives the MDX query but it creates a hierarchy among the dimensions as it is a pivot table and not a simple table.</p>