Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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'
Solved! Go to Solution.
Hi @Anonymous ,
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.
Hi @Anonymous were you able to find a solution? Seems this error happens from time to time with GA data, I recently had this error again in some of my reports. As a workaround, maybe you can try to test your connection with a 3rd party connector. I currently use windsor.ai's GA connector and my connection is working great so far. In case you wonder, to make the connection first search for the GA connector in the data sources list:
After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:
There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
Hi, i am facing this issue while refreshing my data. Please help
This is the message that i am getting
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):
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
Hi @Anonymous ,
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.
I am experiencing the same issue ittermitently, the my reports using the GA connector return this error at least 3 times a week.
Looks like the error has been fixed now
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.
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
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?
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
14 | |
8 |
User | Count |
---|---|
50 | |
39 | |
32 | |
15 | |
13 |