Get only 2 months old data while loading

[Sachy123]

I have imported Date Dimension which looks as below

DateDimension

DateID DateFormat1 DateFormat2 .. 

Now I want to load another dimension which is in the source data (but not yet connected or related with the DateDimension in my model) 

AccountBalanceDimension



AccountID , DateID  Balance Funds ...

While loading , I want to load Data based on DateID where DateID is between today and last 2 months. 

I am a little new to Power BI , so any simple explanation would be much helpful

[PattemManohar · Accepted solution]

Instead of importing table, use "SQL Statement" option where you can filter the data as you need as well as the columns you would like to import.

[Sachy123]

But how do I connect it to the Date Dimension which is already in the model? 

I mean how can I resolve it using Power Query?

[PattemManohar]

Goto Data Section, Select the table and corresponding date field, use the filter option to set the date range. Make sure you have date field defined on that field.