Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone.
For the last 4 days one of our models ( just one ) stopped refreshing on the web, and we didn't publish any changes to it since two weeks ago.
When we manually refresh it on the PowerBI no errors occur, we are able to publish it with no issues, but when we try a On Demand refresh it takes less than a minute to fail with the message
The gateway operation has been cancelled explicitly by the user or from a timeout.
Solutions that we tried:
No data issues were detected, both the old and the current version refresh just fine on the Desktop just won't refresh on the web.
We are currently out of options as the message is not very clear on what is blocking the refresh. All our other models are working fine and no changes were made to this one before it started failing.
Thanks
Daniel
Solved! Go to Solution.
Just a final update on the matter and some opinions.
tl;dr we had to add a transformation to all of our dates ( they were fine before )
We contacted MS Contact Support for help ( we actually opened 2 concurrent tickets because we were desparate ).
#"NewStep"= Table.TransformColumns( #"Removed Columns", List.Transform( Table.ColumnsOfType(#"Removed Columns", {type date, type nullable date, type datetime, type nullable datetime, type datetimezone, type nullable datetimezone}) , (name) => {name, (date) => if date = null or Date.Year(date) < 101 then null else date, Type.TableColumn(Value.Type(#"Removed Columns"), name)} ) ) in #"NewStep"
Felt the need to share the experience, good or bad. I hope PowerBI becomes more transparent on whats wrong.
Hi @dgolhiardi,
The information here is limited. Please provide the Gateway logs. I will try my best to help. Please send me a private message unless you can make it public.
1. Enable additional logging.
2. Refresh again to gather some logs.
Please be aware of privacy.
Best Regards,
Dale
I sent you the gateway logs, but I didn't find any abnormalities comparting to a healthy refresh from other model
Hi @dgolhiardi,
Please send me the whole logs. BTW, do you use the latest version of data Gateway. 14.16.6549.2
Best Regards,
Dale
Here is the link for the gateway logs
https://drive.google.com/file/d/1bCjQ6Ri336sE-fBU5GNz8LVbYZPbJDGm/view?usp=sharing
Updating to the latest version does not work
In the logs we only have warnings in the end
[DataMovement.PipeLine.MashupCommon] Connection string <pi>DSR=**i removed the hash here***</pi> is not a valid M connection string
The refresh still fails under a minute if I try On Demand. On Desktop App manual refresh goes by without errors nor warnings
Just a final update on the matter and some opinions.
tl;dr we had to add a transformation to all of our dates ( they were fine before )
We contacted MS Contact Support for help ( we actually opened 2 concurrent tickets because we were desparate ).
#"NewStep"= Table.TransformColumns( #"Removed Columns", List.Transform( Table.ColumnsOfType(#"Removed Columns", {type date, type nullable date, type datetime, type nullable datetime, type datetimezone, type nullable datetimezone}) , (name) => {name, (date) => if date = null or Date.Year(date) < 101 then null else date, Type.TableColumn(Value.Type(#"Removed Columns"), name)} ) ) in #"NewStep"
Felt the need to share the experience, good or bad. I hope PowerBI becomes more transparent on whats wrong.
Yes, we made sure the gateway is updated.
Just remembering it's only one of our models that is behaving like this, the others are fine
No web data is in use, only PostgreSQL and Redshift.
No errors on the gateway logs also