Forum Discussion

eugenm's avatar
eugenm
Icon for Helper II rankHelper II
2 years ago
Solved

Creating a secondary table that pulls data from a local on

So, I have one table that pulls in 3mil+ rows with lots of columns - lots of data and lots of calculations. I need to manage the madness somehow, refresh wise and continuing development, as I have t...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    It caches what it loaded but it doesn't allow you to "add on" to that.  Power BI Desktop only supports flush and fill  (obligatory comment:  While semantic model self referencing is possible it is not recommended).

     

    Correct, Incremental Refresh is a service thing, not very relevant on the Desktop. On the Desktop you can use RangeStart and RangeEnd to limit the amount of development data.

     

    Creating a dataflow - Power BI | Microsoft Learn

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Power BI has no memory.  You need to either make your data source faster, or you need to think about dataflows or incremental refresh.

eugenm's avatar
eugenm
Icon for Helper II rankHelper II
2 years ago

Hmm, never knew. I thought that it cashes what's loading.
Not sure what you mean by the data flows? 
Incremental refresh will only help once I publish the dash, not during development in my PBI Desktop, right?