Not reading Sharepoint data

[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.

[mpicca13]

Have you checked the data type of the column in the actual excel file?

[jorgeslzr]

Yes, it is the same as the others

[Sumanth_23]

hi @jorgeslzr - One thing you could try is try is make a copy of one of the files that are working and replace the data with the one from the file that is not working - this seems more like a problem with the excel file.

Please mark the above comment as a solution to help others find it more quickly. Also please provide a 👍 if my comment helped with solving your issue. Thanks!

[mpicca13]

Have you also checked the data type in the power query editor for that source?