Huge data Refreshing from SQL

[mohan_g_das1986]

Hi,

We refresh a weekly report from SQL for the last 2 years, which is 4.5 Million lines (Transaction level data). Is there any options in Power BI not to refresh whole lot data & but refresh the last few weeks maybe 5 weeks.

Any clue please provide your Suggestions

[Mariusz · Accepted solution]

Hi @mohan_g_das1986 

Sure, please see the link below.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.