It's glad to hear that pwbi had support incremental refresh for pro user.
I had tried this function last week. But it seems not to work for me.
Here is the detail:
I got 1 file, and duplicate each other and set up in different refresh methods
- Traditional methods in refresh
- Full dataset (16 million data rows)
- Full reports and chart
- File size: 144MB
=> Refresh success, and take around 60 - 90 minutes for each refresh
Here is the result
- Incremental refresh applied
- Same dataset (16 million datasets)
- Full reports and charts
- File size: 21 MB
=> Can not make the 1st successful refresh. It always shows this below error:
- No reports, chart or DAX
- File size: 200Mb
=> Success in refreshing
Here is the picture
I know that it will take a long time for the 1st run. But my consider is, why with the same dataset (16 mil rows), File 02 is not success in increment refresh?
Please help me to solve this problem. Thanks in advance!
@thangtruong So it said it has timed out. My first question would be what is the data source and if it actually can time out?
@JirkaZ hi, thank you for your reply.
For the 1st question, I connect Pwbi with SQL Server, and using IMPORT method (not DIRECT QUERY)
For the 2nd question, as I show in my post, the 1st FILE (with full dataset, full reports, and DAX) takes 60 - 90 mins, which means it not reach 2 hours.
Hope you're going well.
Have you tried refreshing that 2nd file more than once? It would be nice to rule out whether your timeout wasn't simply a coincedence. There can be other stuff going on in your network that can cause you to have a timeout under normal circumstances.
Hi @thangtruong ,
For the issue, please refer to efore the data import for finished, its data source timed out .
Best regards,Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Has your problem been solved?
Thanks for your response
I already try all the methods that I can find in the web, or in this community. But nothing works.
Now I'm working with Power BI Customer's Support (some guys in India) and we are trying to figure the problems out.
Will update to all you guys about my case 😞
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.