cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tie Frequent Visitor
Frequent Visitor

Scheduled refresh failing

Hi, 

I've got a series of reports & datasets setup in Workspaces with daily Scheduled Refreshes running. These have been active for at least 6mths without issues but in the last 48hrs all have failed. Different datasets have given the same general error message of "There was an error when processing the data in the dataset."
Individual errors from datasets include:
"Value was not specified. Table: xxxx1."
"Invalid placeholder in format string. Table: xxxx2"

 

The reports have not been changed in the last week and I can manually refresh them without issues using Power BI Desktop. 
Any suggestions on what could have changed or what I can do to resolve this will be much appreciated. 


Thanks

5 REPLIES 5
Community Support Team
Community Support Team

Re: Scheduled refresh failing

HI @Tie ,

have you update your gateway to last version?(Old version may cause some compatibility issue)
BTW, can you please share some detail information to help us clarify your scenario?(e.g. datasource type, connection mode, detailed error message, request id, snapshots...)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Tie Frequent Visitor
Frequent Visitor

Re: Scheduled refresh failing

Hi, 

The connection isn't using a gateway as all data is cloud-based in Azure environment, Cosmos DB. The request ID for one of the failed refreshes is ca9b3a05-dd11-487b-b4f8-2ed2f768ea03

 

Thanks 

Community Support Team
Community Support Team

Re: Scheduled refresh failing

HI @Tie ,

Where are your pbi data host?(you can find it by click '?' icon -> 'about power bi')

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Tie Frequent Visitor
Frequent Visitor

Re: Scheduled refresh failing

Hi, 

The data is hosted in North Europe (Ireland).

Thanks

Community Support Team
Community Support Team

Re: Scheduled refresh failing

Hi @Tie ,

I traced your request id and find this issue seems more related to azure service:

Could not parse IP address from AAD JWT: System.NullReferenceException: Object reference not set to an instance of an object.
Model (id = 4677292) refresh failed with error, next refresh time will be'05/11/2019 01:00:00', continuous failure count = 3, exception:[0]Microsoft.PowerBI.Common.PowerBIDataMovementBasedRefreshFailure: AS Engine received from Data Movement Service. HttpStatus: 400.

Please contact to azure admin to confirm this or submit a support ticket for this to get better support.

Support Ticket.gifsubmit a support ticket

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 227 members 2,737 guests
Please welcome our newest community members: