Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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.
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.
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
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
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.
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.?
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 ?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
96 | |
46 | |
25 | |
19 | |
18 |