cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
featleyd Regular Visitor
Regular Visitor

Data refresh errors

Hello all

 

Apologies if this is a duplicate post, but I am experiencing an error during scheduled and manual refreshes in the Power BI service.

 

My report uses Google Analaytics and 1 (28Mb) spreadsheet (with multiple data tables in it) as it sources.

 

Suddenly my scheduled refresh has failed to work and it quotes the following error:

Snippet.PNG

The name of the table varies every time.

 

I've searched here and it seems that no-one has found an answer. I've tried re-publishing under a different name, or with a copy of the spreadsheet to no avail.

I've asked my IT team if there is any throttling of data from the file location and they have said no, so I am completely stumped as to why this would suddenly stop working.

 

It works absolutely fine in Desktop, and refreshes consistently without any errors.

 

Does anyone have any help or advice to help me remedy this?

 

Any help is greatly appreciated

 

Daniel

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Data refresh errors

Hi @featleyd ,

I try to use your request id to trace detailed logs but I haven't found clear error message about your issue.  I think it may related to your datasource, is there any changes apply on your datasource side? 

In addition, have you apply any advanced operation in query table?(combine,merge, invoke custom function, reference other query)

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: | |
featleyd Regular Visitor
Regular Visitor

Re: Data refresh errors

Hi @v-shex-msft 

 

Thanks for your response and for looking through the error log.

 

The only change I made to the data source was to add another standard table in Excel, but there was nothing strange about that to my knowledge (i.e. it was a standard Excel spreadsheet with manually typed data into it)

I have not invoked any advanced operations to my knowledge, although my queries are linked.

 

I'd upload the PBIX but its deemed commercially sensitive so I'm not allowed!

 

I've read about throttling data when using Sharepoint as a source, could this possibly be the cause?

 

Daniel

Community Support Team
Community Support Team

Re: Data refresh errors

HI @featleyd ,

Where are your excel stored? local or online?(sharepoint/onedrive)  If you mean online files and get data with web connector, it may managed by onedrive refresh(updated per hour) and not triggered by scheduler refresh.

In addition, you can also submit a support ticket for better support.(I can't find clear caused of your issue in error message)

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: | |
Highlighted
featleyd Regular Visitor
Regular Visitor

Re: Data refresh errors

Hi @v-shex-msft 

 

The source document is stored in a Sharepoint document library. I don't use OneDrive for storing this.

 

I do use the web connector to link Power BI to the dataset, but never had issues with it before.

 

I'll get a ticket logged, but feel free to message here if you find anything 🙂

 

Daniel

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 251 members 2,696 guests
Please welcome our newest community members: