Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 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
    10 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.

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
11 months ago

Hey, Anonymous ,

this means, something tries to reference it, or the incremental refresh is set on that date. In your Power Query, make sure that you select only the columns you want, don't remove what you don'T want, select what you want (ideally write your own SQL, since you work with database), therefore there cannot be reference to that column and then check your filter that it's correctly set up on the new column, which is present and it's not the errored column and then set up the incremental refresh from ground up.

 

Also if youre source allows it, try to remove option to check for schema etc.