Import data from xlsx fles showing nulls and looking weird(?)

[binslync28]

Hi, 
I imported xlsx files originally looking like this:

Completely normal until imported into PBI and now its like this:

There are times it goes back to normal and there's times it doesn't. Anyone encountered the same issue and has solution? Please do tell me. 

Thank you in advance! 

[suparnababu8 · Accepted solution]

Hi @binslync28 

I agree with @Jpss  . Whatever said by @Jpss  that is correct. Additioanlly follow below steps.

• If excel file in protectview it will casue probles. make sure that excel file available for edit.
• Check the data types from excel to Power bi
• There may be chance to expect excel file is corrupted.

If you need more info go through below solved solutions

Solved: Date data showing as "null" despite source data ha... - Microsoft Fabric Community

Power Query import from excel blank thousand rows with null values - Microsoft Community

Solved: Actual values showing as null when import an UNEDI... - Microsoft Fabric Community

[Jpss]

Some times power query  applies transformations  by default. you may need to remove those transformations. 

It would be best if you can share your excel file and pbix file  where you are facing the issue .