How to load month by month data in Power BI

[Anonymous]

Hi All.

I have a requirement to connect to a source system using Rest API. I would need the data from a table from the year 2019 till data. To reduce the load on the system, we are asked to load the data month by month from the year 2019. Could you please help me on how I can do a month by month load?

The Rest API used is as below which brings in data for Jan 2019, same way I need data till current data always month by month.

[Greg_Deckler · Accepted solution]

Well, you could create 12 queries, one for each month and do an Append at the end. So, first query, load. Turn off refresh. Second query, load, turn off refresh, etc. Then do an Append.

[Anonymous]

Hi Greg_Deckler,

We are planning to go ahead with this approach, Could you please help clarify the below>

1. Say I created a query for Jan, Feb, March etc, I load this query,  then I go back to the editor and turn off refresh. Then I schedule the report in the Service.

By turning off refresh would I still get the changed records for these months ?

Thanks

Poojitha 

[Anonymous]

Hello Power BI experts,

Can somone please help on providing the best approach for this as I am waiting for this to move ahead with one of the project. Your help will be much appreciated .

Thanks

Poojitha

[Anonymous]

But this will turn out to be a manual activity as every month a new query has to be created and appended as we always want the latest data.
We are looking for an automated solution .
Is there any other workaround ?

[V-lianl-msft]

Hi @Anonymous ,

You can learn more about incremental refresh.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh 

Incremental refresh is generally available and supported in Pro.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Do I need to load all the data first and then later set up incremental refresh to pick on the new records? 

I tried to load the entire data by removing the date range parameter from the rest api and used the below api, but it gave me a time out error.

Can somone pls provide inputs on this.? 

[Anonymous]

Hello,
Thanks for providing the details , but in my case the Rest api itself is restricted to only to show one month . (Please refer the Screen shot attached in the question : highlighted in red).
In such case we are importing only one month data in the desktop .
Can you pls let me know how incremental refresh works here ?