Forum Discussion
Power BI Desktop Refresh
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:)
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