Forum Discussion
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.
- Anonymous1 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
- AnonymousNot 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_PalAdvocate II
Thank you Anonymous for the reply.
Please let us know if you get any updates.- AnonymousNot 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.