Power BI Desktop Refresh

[yannaingoo]

Hello there

In Power BI Desktop, when i refresh the data, there is loaded all the rows from tables. Once my data are grew there will be a problem refresh data. loading millions rows everytime. Let me know if there a solution to that. Thanks

[MasonMA · Accepted solution]

Hello @yannaingoo 

If in desktop, as a developer to avoid loading massive data when I refresh, I would normally set up a Parameter in Power Query like DevMode (True/False), and apply filters based on below logic to limit rows from Power Query (once the Parameter is created, you can also set up via UI)

if DevMode then
Table.SelectRows(Source, each [Date] >= Date.AddDays(DateTime.LocalNow(), -30))
else
Source

For details please refer to this YouTube Tutorial from 'Guy In a cube'

https://youtu.be/_zYvybVMk7k?si=vyakV5G2MhMQoxDR

Hope this gives you some ideas:) 

[yannaingoo]

This is awesome!

[MFelix]

Hi @yannaingoo ,

If you are in the desktop, you need to implement a filter that will force your model to just show a few lines using a parameter on your model, then when moving to the service you can change that parameter to an higher value.

Assuming you are using a SQL Server you can Use a SELECT TOP N syntax and define the number of rows in a parameter that will only force that fews rows in desktop.

https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

[FBergamaschi]

Solution is Incremental Refresh

Here some videos explaining it

https://www.youtube.com/playlist?list=PLv2BtOtLblH3lwpQ5NBq6kD6fsVziO9sE

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI