Forum Discussion
Power BI Desktop Refresh
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
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:)
4 Replies
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
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
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:)
This is awesome!
