Forum Discussion
Memorable MemberHow to remove error when loading raw data to PBI ?
Hi All
My sales Table when load 1000 row of data , i get 40 error. if loading 2000 row of data i get 80 error.
Hi admin11 ,
It should be that the value of some fields is "error", please check the values in Power Query.
You can replace the error values or delete them or modify them.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
v-lionel-msftCommunity Support
Hi admin11 ,
It should be that the value of some fields is "error", please check the values in Power Query.
You can replace the error values or delete them or modify them.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
admin11Hi All
Below is my PBI file :-
https://www.dropbox.com/s/4f0uqlitg9gmuii/PBT_V2021_302%20LOADING%20MANY%20ERROR.pbix?dl=0
- PhilipTreacy
Super User
Hi Paul,
I can't open the file and reproduce the errors because I do not have access to your files on your Sharepoint.
You'll have to review the errors as I described and then provide more info on what those errors are.
Regards
Phil
- PhilipTreacy
Hi Paul,
You'll have to check what the errors are and fix them.
Click on the View Errors link in the top right of that dialog box and review the errors.
Phil
