Forum Discussion

ReznorTonya's avatar
ReznorTonya
Frequent Visitor
3 years ago

Service Refresh Help

I have a very complicated report with a number of measures and calculated columns.....I have spent days trying to figure out where it is failing.  I can publish my report to the service just fine and...
General Comment
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  ReznorTonya ,

What "refreshes everything displays incorrectly" refers to, whether the data is inconsistent with the Power bi Desktop or is it generating an error message.

 

If the former, whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.

And check the filter and slicer status, whether Power BI Desktop and Power BI Service are set the same.

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky

 

If the latter, you can post the error message after it is refreshed and we can help you better.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ReznorTonya's avatar
    ReznorTonya
    Frequent Visitor
    3 years ago

    Hi thank you so much for the quick response, what I mean by "refreshes and everything displays incorrectly" As you can see from the image below, my report has 4 levels of indicators with black (D4) being the lowest value, when opened in the desktop the data displays correctly, in PBI Service after refresh it all displays as black.  I am not using any date/time fields, just straight dates BUT am using today() in the following DAX formula 

    TStatus = 
var EmpAssist1 =
    if(ISBLANK(Readiness[Employee Assistance ].[Date]), TODAY(), Readiness[Employee Assistance ].[Date])
var EmpAssist2 =
    If(EmpAssist1 <= [Employee Assistance 0].[Date], 1, 0)

var Clinic1 =
    if(ISBLANK([Clinician Self-Care_].[Date]), TODAY(), [Clinician Self-Care_].[Date])
var Clinic2 =
    IF(Clinic1<=[Clinician Self-Care_0].[Date], 1, 0)

var Welcome1 =
    if(ISBLANK([CDT Welcome Video].[Date]), TODAY(), [CDT Welcome Video].[Date])
var Welcome2 =
    IF(Welcome1<=[CDT Welcome Video_x0].[Date], 1, 0)

var TBasics1 =
    if(ISBLANK([CDTTravelBasics-DateCourse].[Date]), TODAY(), [CDTTravelBasics-DateCourse].[Date])
var TBasics2 =
    IF(TBasics1<=[CDT Travel Basics_x0].[Date], 1, 0)

var Triage1 =
    if(ISBLANK([Triage Course _x0028].[Date]), TODAY(), [Triage Course _x0028].[Date])
var Triage2 = 
    IF(Triage1<=[Triage Course _x00280].[Date], 1, 0)

var PSY1 =
    if(ISBLANK([Psychological First ].[Date]), TODAY(), [Psychological First ].[Date])
var Psy2 = 
    IF(PSY1<=[Psychological First 0].[Date], 1, 0)

var ICS1 =
    if(ISBLANK([ICS-100 Introduction].[Date]), TODAY(), [ICS-100IntroductiontotheIn].[Date])
var ICS2 = 
    IF(ICS1<=[ICS-700 National_x00].[Date], 1, 0)

var ICS3 =
    if(ISBLANK([ICS-700NationalIncidentMan].[Date]), TODAY(), [ICS-700NationalIncidentMan].[Date])
var ICS4 = 
    IF(ICS3<=[ICS-700 National_x00].[Date], 1, 0)

var Fundamentals1 =
    if(ISBLANK([CDTFundamentals-CourseDate].[Date]), TODAY(), [CDTFundamentals-CourseDate].[Date])
var Fundamentals2 = 
    IF(Fundamentals1<=[CDTFundamentals-CourseDate].[Date], 1, 0)

var TCARD1 =
    if(ISBLANK([Travel Card Course_x].[Date]), TODAY(), [Travel Card Course_x].[Date])
var TCARD2 = 
    IF(TCARD1<=[Travel Card Course_x0].[Date], 1, 0)

var HIPPA1 =
    if(ISBLANK([HIPPACourse-DateCourseComp].[Date]), TODAY(), [HIPPACourse-DateCourseComp].[Date])
var HIPPA2 = 
    IF(HIPPA1<=[HIPPA Course Due].[Date], 1, 0)

var Telework1 =
    if(ISBLANK([Telework-VAVideoConnectTra].[Date]), TODAY(), [Telework-VAVideoConnectTra].[Date])
var Telework2 = 
    IF(Telework1<=[Telework-VA Video_x0].[Date], 1, 0)

Return
/*EmpAssist2 & Clinic2 & Welcome2 & TBasics2 & Triage2 & Psy2 & ICS2 & ICS4 & Fundamentals2 & TCARD2 & HIPPA2 & Telework2
*/
IF(
    EmpAssist2 && Clinic2 && Welcome2 && TBasics2 && Triage2 && Psy2 && ICS2 && ICS4 && Fundamentals2 && TCARD2 && HIPPA2 && Telework2
     = 1, 1, 0)