Not reading Sharepoint data correctly

[jorgeslzr]

Hi, I know I am not saying much but I cant share pictures or data because is the company's data. But still I will ask the question. Hope anybody can help.

I am doing a .pbix that gets the data from several Excel files via Sharepoint. All files have the same table (same shape, same column names, data type, data validation, etc) with the same table name. But for one column, in a specific file, it is not reading its values, it gives null values on all rows. Interestingly, it does read the column name and the rest of the columns are fine.

As mentioned, the rows have the same type of data as in the other files, the table is exactly the same. But I have no clue why that specific column in that specific table from that unique file is not read. 

Can anybody give me a clue where to look for the error or something?

Thanks.

[amitchandak]

@jorgeslzr , do you see any kind of error on power query/edit query mode?

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s