Forum Discussion
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 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.
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:
- what-do-enable-load-and-include-in-report-refresh-mean-do
- 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.
6 Replies
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?
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 clausesI 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.
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.
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:
- what-do-enable-load-and-include-in-report-refresh-mean-do
- 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.
