Forum Discussion
incremental refresh goes for full refresh during Pbix change
Hi, We are using Power BI - Pro version. Currently it is full refresh method. The full refresh is always working fine from Power BI Desktop but some times it gives time out error from Power BI servi...
- Hi there
Have you had a look at changing the timeout if your source is a SQL Server source?
https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-using-a-sql-server-source/
With regards to question 2:
It will always do the full refresh in the Power BI Service, because it has to create the underlying partitions.
Question 3: Currently this is only supported in Power BI Premium
GilbertQ
Super User
Super UserHi there
Have you had a look at changing the timeout if your source is a SQL Server source?
https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-using-a-sql-server-source/
With regards to question 2:
It will always do the full refresh in the Power BI Service, because it has to create the underlying partitions.
Question 3: Currently this is only supported in Power BI Premium
Have you had a look at changing the timeout if your source is a SQL Server source?
https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-using-a-sql-server-source/
With regards to question 2:
It will always do the full refresh in the Power BI Service, because it has to create the underlying partitions.
Question 3: Currently this is only supported in Power BI Premium
Thanks much for your response !
for Q1: We have tried this option . Looks like this resolve the time out issues at the database side. However my issue is on the Power BI scheduled refresh as it is Pro version, it will get time out after 2 hours !
For Q2: My PBIX file goes for frequent changes. At least twice in a week we have to publish the modified pbix in to service . In this scenario , is it advisable for full refresh instead of Incremental? Any suggestions?- GilbertQHi there
That might work in overriding the timeout issue.
Q2, if you make updates and have to update the PBIX and it is only visual elements you might be better of changing it in the Power BI Service.
If you re-upload a PBIX it has to re-create the Incremental refresh partitions each and every time.