Forum Discussion

jordan-ingles's avatar
jordan-ingles
Regular Visitor
3 years ago

Error in the Data

Hello! Hoping someone can help me. I have uploaded data into the Power Bi Desktop but it keeps telling me there is an error. When I filter on the errors alone - the table is empty (image for reference) What am I doing worng here? Please help me!

 

 

 

 

Need Help
Tips and Tricks

10 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    3 years ago

    Hi jordan-ingles 

     

    It's difficult to help you without seeing the actual file and data.  But lookgin at your image, it is filtering for errors only in the SALESID column, and I guess there aren't any.

     

    What error message are you getting when you import the data?

     

    What does the table show/look like before you filter for errors?

     

    Please provide your PBIX fiel and the data you are trying to import.

     

    Regards

     

    Phil

     

    • jordan-ingles's avatar
      jordan-ingles
      Regular Visitor
      3 years ago

      Hey Phil,

       

      Thanks for your help! Really appreciate it. There is an error in every column of my data. I dont have any issues importing the data but when I refresh the data from excel it tells me that x number of rows were added and x number of errors were found and the report wont then refresh with the new data. 

      I dont get a specific error. 

      The table looks totally fine! It just wont refresh the report.

       

      Hope that all makes sense? 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        Hi,

        Share the download link of the PBI file along with the source Excel files.