Imported data from an online Excel file on Sharepoint, and got errors and some data loaded

[vmo416]

Hello all,

Fairly new to Power BI so this might be a repeat message, I have connected an online excel file to Power BI, and as I loaded the data, I got this error.

I am unable to determine what the error is and if I include the errored data in the load and try again:

I then get this error:

How do I determine what the errors are, as I click "View Errors", there is nothing specific that shows up?

[MurtoMan]

Did you connect the Excel file as web source? That is the correct way to do it from Sharepoint.

Just open the Excel in desktop application and browse File - Info - Copy path.

Copy that path as a web source and remove all from question mark to end.

[amitchandak]

@vmo416 , scroll and check there should be an error column. 

Refer video from Curbal : https://www.youtube.com/watch?v=OE6DPmKqN7s