Is there any way I can edit the power query and make the Year > 2018 in power bi report service ?

[suvechha]

Hi there ,

I have a ms sql server db connection to the one specific view with Year > 2020 . But I want to 2 more years i.e from 2018.

But with my Power BI Desktop power query its going out of memory . 

I have created on-premise data gateways in power bi report service.

Is there any way I can edit the power query and make the Year > 2018 in power bi report service ?

Thanks

[Anonymous]

Hi @suvechha,

If you are working with SQL data connector and common SQL table, you can add a custom t-SQL query in advanced option -> SQL statement to get filtered records.

Power Query SQL Server connector - Power Query | Microsoft Docs
If you are working with a view that includes a specific filter effect applied on the database side, I don't think you can do custom form power bi side to ignore the original effect and apply new filter effects. (power bi does not include write back features)

Regards,
Xiaoxin Sheng

[Shahfaisal]

If you have the required permissions, you can write a query and use it in Power Query. However, if you are using a view that has a filter on year > 2020, you won't be able to change that logic in Power Query as the data is already filtered at the database level. 

Try writing a sql script with your own filters and then use it in Power BI Desktop (Power Query).