Error in the Data

[jordan-ingles]

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!

[jordan-ingles]

It wont let me attached the excel source file?

[Ashish_Mathur]

Upload the PBI file and source Excel files to Google Drive and share the download link.

[jordan-ingles]

SO Order Analysis.xlsx

Try this?

[Ashish_Mathur]

Hi,

That takes me to a sign-in page.  Also share the download link of the PBi file where the problem is occuring.

[PhilipTreacy]

@jordan-ingles 

That requires a login to access it.

Can't you save the file to OneDrive, Dropbox or Google Drive and link to it?

regards

Phil

[PhilipTreacy]

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]

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? 

[PhilipTreacy]

Hi @jordan-ingles 

Very difficult to help you without seeing your data and the PBIX file/query you are using.

Phil

[jordan-ingles]

Hi Phil,

Sorry this is my first time building a report. It wont let me attach an excel document? How do I access my PBIX file?

[Ashish_Mathur]

Hi,

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