Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

help in refresh in Power BI service

Dear community,   I am facing issue in refresh of a report in power Bi service (it has incremental refresh) . It was working fine until 2 days ago. When I refresh it in POwer BI service it returns ...
Need Help
  • v-echaithra's avatar
    v-echaithra
    9 months ago

    Hi Anonymous ,

    Thanks for the update. The issue might be due to the old partitions that weren’t fully cleared before the refresh. When you disable incremental refresh and republish, the Service still retains historical partitions unless you explicitly delete them. Try these below steps by using some sample data.

    Disable incremental refresh in Desktop and refresh locally.
    Publish to Service, overwrite dataset.
    In Power BI Service > Dataset Settings > Incremental refresh history,
    Delete all partitions (this step is critical).
    Trigger a full refresh in Service, this rebuilds schema without incremental logic.
    Re-enable incremental refresh in Desktop, set RangeStart/RangeEnd, and publish again.
    Run the refresh again in Service.

    Hope this helps.
    Thank you.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
10 months ago

Hi Anonymous 

 

Can you confirm if you open up Power BI desktop and click on refresh, it will refresh successfully? What you could possibly do is if that happens, you could use the ALT toolkit. To publish any changes between your Power BI version and the version in the Power of BI service, you could then use something such as Tabular Editor 3 or SQL Server Management Studio to refresh the individual partitions to avoid the 5 hour timeout.