Parameter for Removing the Date Filter

[Anonymous]

Hi All,

thanks in advance,

in my organization, we work on the 2 copies of the Power Bi pbix file.

1st one is filtered data the record count is almost 80 lakh we do day to day activity on the first copy we do create a report based on the 1copy too ( here we have date filter applied in power query to reduce the size of the data & the business need)

2nd will be a clone of 1st file excluding the date filter when we remove the date filter in power query row count will 5 crores we do create a report based on the 2copy also

the challenge is whenever we clone the data or remove the applied step data load or data refresh will take 4 hours to refresh in Power Bi desktop

is there any possibility to create a Parameter to ignore or remove the applied step so we can save a lot of time in the refresh. if any possibility please share the steps to create

first, filter the data later on while cloning the file use Parameter for start date & end date 

#"Filtered Rows" = Table.SelectRows(GL_GL_Info_Report, each Date.IsInCurrentMonth([Period Date]) or Date.IsInPreviousNMonths([Period Date], 26)),

Data is loaded in Import Method

[amitchandak]

@Anonymous , if data is imported. In the right pane, you have an option to remove steps. (X sign with each step), is that needed ?

You can copy table paste again in edit query mode to have another copy.

[Anonymous]

@amitchandak thanks for your replay, I need to remove the applied step for the table using a parameter or parametrize the start date & end date on currently applied step is

#"Filtered Rows" = Table.SelectRows(GL_GL_Info_Report, each Date.IsInCurrentMonth([Period Date]) or Date.IsInPreviousNMonths([Period Date], 26)),