Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI is not showing local time when data source is SQL server Analysis services.

I want to show the cube last refresh time (in local) in powe BI. My data source is SQL Server Analysis Services (Tabular Model)

 

I cannot go for hardcoding because I need this deploy to this code to all the production servers.

 

But power BI is showing only UTC time when I deploy to server. Can some one help me in this.

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    One option we used once was to set this as a value in the cube as the cube build was completed - SSIS.   Then available for use from the cube by any query.   Yes does require a cube change.