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

Data Source

Hi, Hope you can Help

In the PBI Service i am suddenly getting errors with autmatic refresh with the below error but i cannot find any field that shows this field error. We currently save all datasets in the cloud and do not use the ON-Premisies Gateway

 

Hope you can help

Regards

Dan

 

'Data source error: The field 'errors' of the record wasn't found.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID: 98051803-f45b-49e4-9769-0239cf2d76cc
Request ID: ba904f15-3a7e-49e3-b60f-268f3a4423b9
Time: 2021-10-11 13:25:51Z'

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Dan_Crowther ,

 

This issue has been reported internally (ICM#: 266435923). According to the latest update, it has been fixed. Please check if they are working in your scenario.

 

Best Regards,

Liu Yang

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

View solution in original post

12 REPLIES 12
goliash
Frequent Visitor

Hi guys,

 

This error is not Google analytics related.

I´m getting the same error using the MS Project Online content pack. The fact table Projects is causing the problem. It is not possible to change the name of the table in the source MS Project Online (part of O365):

  • Data source errorOData: Fehler beim Verarbeiten dieser Anforderung.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

When I´m trying to debug the error in Power Query the Source is correct, in Navigation step is causing the problem even the Projects table is offered in Navigation step.
Please advice, the update did not solved the issue.

 

Goliash

v-yangliu-msft
Community Support
Community Support

Hi  @Dan_Crowther ,

 

This issue has been reported internally (ICM#: 266435923). According to the latest update, it has been fixed. Please check if they are working in your scenario.

 

Best Regards,

Liu Yang

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

View solution in original post

Sbudd
Helper I
Helper I

Looks like the error has been fixed now

DonalMc
Helper II
Helper II

I also just started getting the below error message on some scheduled refreshes. The reports include Google Analytics as a data source. I don't get any error when I refresh on the Desktop. It's good to know that others are seeing the same error.

 

The field 'errors' of the record wasn't found.. The exception was raised by the IDataReader interface.

Sbudd
Helper I
Helper I

I too have just started getting these errors, I am going to rebuild the Google Ananlytics connections and see if that helps...I'll let you all know

Hi,

Thankyou for responding and good to know its not just me. Its strange that if i manually refresh each Google Analytics data source within the Desktop version, it doesn't show any issues, more the scheduled refresh in within the PBI Service version. But great if you can let me know any of your findings

 

Regards

Dan

Unfortunately I rebuilt all my GA tables and still had the same issue, I then just tested with a blank dashboard with just a single connection to GA looking at only Date and Users and this still failed.

Hi Sbudd

Thanks for letting me know, so looks like we just have to play the waiting game to see if Microsoft/Google can fix the API connector/Service issue. I hope they are onto it

 

Regards

Dan

joshep_blanco
New Member

Hello, I'm presenting the same issue today. 

Thank you @Burningsuit, could you tell me where the field "errors" could be allocated? In my case, I have not changed the data sources.

 

Hope you can help us.

Regards

This error seems to happen when refreshing Google Analytics, not an error in the data as I first thought. It appears to be linked to the Google Analytics interface. If your Dataset does not include Google Analytics data, even if it does, you may want to raise a support ticket with Microsoft to get it looked at.

hope this helps 

Stuart

Yep i just started getting this error this weekend as well. I downloaded and refreshed the report on PowerBI Dekstop and got no errors so it is isolated to the refresh occurring on PowerBI online. I do have a connection to Google Analytics so I guess this may be the problem. Do you have a fix for this yet or should i report an error? 

Burningsuit
Solution Sage
Solution Sage

Hi Dan,

My reading of this message is that the column "errors" in the data source has been removed and either Power Query or Power BI was using that column, so the Service throws this message out to say it can't refresh.

Has the data source changed ? Was there a column called "errors" in the past that's not there now ?

Hope this helps

Stuart

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors