Step by step importing

[Anonymous]

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 step, 1 month at a time. Now I have no clue how to do this because it just rewrites everything when I change some filters.

[Anonymous]

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 · Accepted solution]

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.

[PC2790]

Hello @Anonymous ,

Can you please provide more information as in:

1) Where is the data residing?

2) The structure of the data?

3) Is the data in installments, as in will you be able to break the data to load it in installments?

[Anonymous]

The data sits in our SQL server. 
I don't really have an answer whats the structure, the basic? I read it like: Basic structure of an SQL expression consists of select, from and where clauses

I don't really have an answer for nr3 either, it's just a simple SQL Server where I import my data into PBI.

Is this really this complicated? I was hoping there was a more straightforward solution for such a big program.

[PC2790]

I am not sure if you have alreadt tried it but you can use Advanced option in Import mode and write SQL statement to do month wise import:

Select * from table where datediff(month,yourdate,getdate())=0 (for this month)

After importing, rename it as per the month name and then import another set.

I think this would work.

[Anonymous]

If I do that then incremental refreshing won't work, otherwise that what I used to do yes.