Skip to main content

    Power BI

    Needs Votes

    Issue: Date formats from a calculated table change from hierarchy to date after a refresh data source

    Vote (2) Share
    Antonio José Resende de Campos's profile image

    Antonio José Resende de Campos on 30 Oct 2019 20:29:32

    I have a date column in a DAX calculated table (an aggregation of another table from a sql server data base). I use this date hierachy year on filter slicers and month on the X axis of column charts.

    Every time I refresh data source on Power BI Desktop this column reverts to datetime format and I have to manually set it back to hierarchy.

    This issue does not happen on Scheduled Refreshes at PBI Services.