Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have been trying to get incremental refresh wotking on one of my tables since 2 days with no success. I have gone trhought he docs and also watched few videos but nothing seems to work. I have a premium per user license.
Need help
Regards
Ballabh
Solved! Go to Solution.
Yes, perfect. Change the parameters and Business Date column from Date to Date/Time data type:
Hi, you're going to have to be way more specific about what you've tried, it's impossible to help you with such a vague question. Explain what you did, where you did it (e.g. desktop, service), and include screenshots. See the first link in my signature.
Environment - PowerBi connected to local Sql Server
Current Process - Whenever we update new data in Sql, we refresh the complete data which takes almost 1.5 hours as there are more than 27 million lines. Once the data is refreshed in power bi desktop, we publish the same for all users.
Assumption : Incremental refresh would reduce the time as it would refresh only the delta data.
Step Taken as below
Table Name - Articlewisesale
Column Name - Business Date
1. Clicked on transform data
2. created 2 parameters
RangeStart = 01/01/2020
RangeEnd = 31/12/2025
3. Custom filtered the column business date with above parameters
4. Complete data got loaded once.
5. not able to get rid below error
Can you post screenshots so that we have more details about your issue?
Hi @otravers
Acutally, I have implemented the Incremental refresh on a table but its taking the same time to refresh as the Normal Full Refresh.
Any Ideas? what will be wrong?
Read the part about query folding in the following doc, lack of query folding is the most likely reason why incremental is not really happening and you end up doing full refreshes:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#query-folding
Hi @otravers
how to verify that and I have already applied incremental refresh what should I do?
https://docs.microsoft.com/en-us/power-query/power-query-folding
Can you show your filter step in Power Query for the Articlewisesale table?
I hope I sent you the correct screenshot
Yes, perfect. Change the parameters and Business Date column from Date to Date/Time data type:
HI.. Just wanted to ask if I can continue with this thread. Although you have solved my initial query. I did all the configs.. but when I refreshed the data today, it again took the complete 27.2 million lines
The first refresh in the service has to be complete to create historical partitions.
Can you please guide me on how can I do that.. Please
This is handled for you by the Power BI service, subsequent refreshes after the initial one will be incremental per the rules you defined in the desktop:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#refresh-dataset
Hi.. It Still didnt worked as expected, attaching a few screenshots of the settings which I have done, i hope they are helpful in identifying my miss outs. Please help
Thanks.. I will follow this and will get to know the impact tomorrow. Will reach out to you again.. Thanks once again
Thanks a ton. You are awesome. Now I know exactly the place to come to for my Power BI queries.
Thanks once again.
Ok. Will get back in an hour and a half as the change will again load the complete data once. Thanks a lot helping
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.