Forum Discussion

Siddhesh_Pal's avatar
Siddhesh_Pal
Advocate II
1 year ago
Solved

Getting error in schedule refresh

Hi Community,

 

I am getting an error in the Power BI service schedule refresh (the error is attached), my concern is why I am getting an error in the Power BI Service.
When I manually refresh the report from Power BI Desktop I don’t get any error.
For some days, I have been getting this error and after 10-15 days the error has been gone.
So, my question is, why am I getting these errors, and why did it disappeared after a few days?
Schedule refresh has started working without any change in the DAX.
 

 



I have attached the DAX for the reference
 

 

WeightedForecast =

GENERATE (

    VALUES (DateTable),

    FILTER(

        msdyn_quotelinetransaction,

        DateTable[Offset] > (msdyn_quotelinetransaction[StartDateFormated]-TODAY()) &&

        DateTable[Offset] <= (msdyn_quotelinetransaction[EndDateFormated]-TODAY()) &&

        DateTable[Full Date] <> "" &&

        msdyn_quotelinetransaction[Transaction Class] = "Time" &&

        msdyn_quotelinetransaction[Transaction Type] = "Project Contract" &&

        (RELATED(quote[statecodename]) = "Active" || RELATED(quote[statecodename]) = "Draft") &&

        RELATED(quote[statuscodename]) = "In Progress"

    )

)

 

 

 

DailyForecast = SUMMARIZE(

    WeightedForecast,

    WeightedForecast[Full Date_WeightedForecast],

    "TotalDailyForecast",

    SUM(WeightedForecast[DailyHours]),

    "MaxDailyForecast",

    SUM(WeightedForecast[MaxDailyHours])

    )

 

 

 

WeightedForecast =

GENERATE (

    VALUES (DateTable),

    FILTER(

        msdyn_quotelinetransaction,

        DateTable[Offset] > (msdyn_quotelinetransaction[StartDateFormated]-TODAY()) &&

        DateTable[Offset] <= (msdyn_quotelinetransaction[EndDateFormated]-TODAY()) &&

        DateTable[Full Date] <> "" &&

        msdyn_quotelinetransaction[Transaction Class] = "Time" &&

        msdyn_quotelinetransaction[Transaction Type] = "Project Contract" &&

        (RELATED(quote[statecodename]) = "Active" || RELATED(quote[statecodename]) = "Draft") &&

        RELATED(quote[statuscodename]) = "In Progress"

    )

)

Any help would be appreciated.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Siddhesh_Pal 

     

    Check here to see if the problem has been fixed. Please refresh and check to see if the problem still exists?

     

    Best Regards,

    Community Support Team _Charlotte

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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Siddhesh_Pal 

     

    This is a known issue. We have submitted it internally and are currently awaiting feedback. I will keep you updated on any progress. The issue can be mitigated by changing the CalendarAuto to Calendar function.

     

    Best Regards,

    Community Support Team _Charlotte

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

    • Siddhesh_Pal's avatar
      Siddhesh_Pal
      Advocate II

      Thank you Anonymous for the reply.
      Please let us know if you get any updates.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi, Siddhesh_Pal 

         

        Check here to see if the problem has been fixed. Please refresh and check to see if the problem still exists?

         

        Best Regards,

        Community Support Team _Charlotte

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