Forum Discussion

tvathis's avatar
tvathis
Frequent Visitor
2 years ago
Solved

Refresh with less rows pulled

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 pul...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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