Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Refresh is not triggering when pooled from Via Enhanced API in power bi service(Data set) Semantic

Hi Team,
I'm facing one challenge here in refresh .. Refresh is success when On demand (Full refesh)  and Via API (Full refesh) ..but Refresh is not triggering when pooled from Via Enhanced API in power bi service(Data set) Semantic model.. here is the code which i return 

I have taken blank query with =datetime.utcnow() and please check below image and code . Please help , any thing to be change in code when VIA Enhanced API also refresh success. 

 

 

Date update =
IF(
    DATEDIFF(LASTDATE('Last refresh date'[Last refresh time]),UTCNOW(),MINUTE) < 60,
    CONCATENATE( DATEDIFF(LASTDATE('Last refresh date'[Last refresh time]),UTCNOW(),MINUTE) ," minutes"),
    IF(
            DATEDIFF(LASTDATE('Last refresh date'[Last refresh time]),UTCNOW(),HOUR) <24,
            CONCATENATE( DATEDIFF(LASTDATE('Last refresh date'[Last refresh time]),UTCNOW(),HOUR)," hours"),
            CONCATENATE(DATEDIFF(LASTDATE('Last refresh date'[Last refresh time]),UTCNOW(),DAY)," days")
    )
)