Forum Discussion

yannaingoo's avatar
yannaingoo
Advocate I
1 year ago
Solved

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. Le...
Need Help
Show and Tell
Tips and Tricks
  • MasonMA's avatar
    MasonMA
    1 year ago

    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:) 

     

     

MasonMA's avatar
MasonMA
Super User
1 year ago

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's avatar
yannaingoo
Advocate I
1 year ago

This is awesome!