current date and time in my report based on SSAS

[FedorFFF]

I want to show current date and time in my report

 Report is based on SSAS (on premise)

( 3 visuals based on SSAS cube  - Multidimensional ) 

 just label in upper corner

like it was in SSRS using system var
 
 
 I read this https://community.powerbi.com/t5/Desktop/Display-current-date-and-time/td-p/169057
 but NOT get idea 
 Why I should create measure ???

Moreover new measure and column are disabled in menu.

ps to be more exact I will need to see datetime of Last refresh when report is published to inet

[v-huizhn-msft]

Hi @FedorFFF,

You get data from SSAS in live connect, right? If it is, you can't create a measure or calculated column because it's a limitation for live connection to SSAS. I suggest you publish the report to Power BI service, right click the report->pin to dashboard. Click the upper corner(...)->edit details->turn on "Display the last refresh time", the refresh time will now show at the top of the tile.



More details, please review this similar thread and article below. The use Query statement to display refresh time is not appropriate for your scenario, because you can't edit query in live connection mode.

Automatically adding date for last refresh of data

Display Last Refreshed Date in Power BI

Best Regards,
Angelia