Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago
Solved

How 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.  
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

     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 Chen

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

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

 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 Chen

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