Refresh with less rows pulled

[tvathis]

Hi!

Is there a way to cut down the number of rows that are refreshing from my table? 

I originally added this from the SQL server as an import. 

I only need the last 2 years of data, but it is pulling everything (over a million rows). 

Just wondering if there's a way that I can cut down the time it takes to refresh? 

Thank you in advance for any suggestions. 

Thank you! 

[v-jiewu-msft · Accepted solution]

Hi  @tvathis ,If I understand correctly, the issue is that you want to refresh with less rows. To solve the issue, you can follow these steps:

1.Import the data from SQL Server.

2.Go to the Home tab and click on Transform Data to open the Power Query Editor.

3.Locate the query that is pulling data from the SQL Server table.

4.Select the column that contains the date information.

5.Apply a data filter to only include the rows where the date.

6.Click Close and Apply to apply the changes and return to the Power BI.

7.Go the Home tab and click on Refresh.

Alternatively,  you can modify your SQL query to to include a WHERE clause that filters the data based on the date column. This way, you’re only importing the data within the last two years.

Looking forward to your reply.

Best Regards,

Wisdom Wu

[Ritaf1983]

Hi @tvathis 
You can use incremental refresh.

Please refer to :

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

https://www.youtube.com/watch?v=Kui_1G6kQIQ

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly