Loading Data

[Carlaf]

Good morning,

I'm trying to load sales' data from a ODBC database.

I'm filtering the table in the power query editor because i need data from year 2018.

The loading process doesn't work.

Do i neen to load the same table many times??

Thanks

Carla 

[Carlaf]

I tryed to select the years from the power query area but it was too slow.

In the end i used a sql statemen's with the where clause inside of it.

[Samarth_18]

Hi @Carlaf ,

As @Ibendlin suggested it would be very helpful to answer if you could explain more about the process which you are following and any errors you are getting.

However, you could try to create a new column in the power query as below and then filter the year:-

Thanks,

Samarth

[lbendlin]

The loading process doesn't work.

Please be more specific.  What have you tried and where are you stuck?