Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Step by step importing

Hi   Can anyone show me a link or tell me how to do step by step importing? I need data into my report from 2020 but doing this in 1 go just overwhelmes our servers so I was told to do it step by s...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    When you create tables for each month, you may not append them as one new table so that it would not nave native query.

     

    "Clicked save and load and boom this thing still reloads EVERY months data..."

    Please check whether these months tables could show the corresponding month value and filter conditions are correct.

     

    Here is an article that introduces sql server database and incremental refresh in power bi that you can refer:

    Power BI Incremental Refresh for SQL Sources 

     

    In addition, if you do not want to load much tables and refresh them in power bi, you can disable these options so that they would not load in models.

    Please refer:

    1. what-do-enable-load-and-include-in-report-refresh-mean-do 
    2. Performance Tip for Power BI; Enable Load Sucks Memory Up 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I tried to create a few more queries with month filter changed for each month. turned off refresh and appended those 3 queries as 1. Clicked save and load and boom this thing still reloads EVERY months data...

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    When you create tables for each month, you may not append them as one new table so that it would not nave native query.

     

    "Clicked save and load and boom this thing still reloads EVERY months data..."

    Please check whether these months tables could show the corresponding month value and filter conditions are correct.

     

    Here is an article that introduces sql server database and incremental refresh in power bi that you can refer:

    Power BI Incremental Refresh for SQL Sources 

     

    In addition, if you do not want to load much tables and refresh them in power bi, you can disable these options so that they would not load in models.

    Please refer:

    1. what-do-enable-load-and-include-in-report-refresh-mean-do 
    2. Performance Tip for Power BI; Enable Load Sucks Memory Up 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.