Data not detected suddenly

[fanhui3]

HI, my dashboard was working fine for months. However, today, it stopped detecting many of the cell in my excel file. Does anyone face the same issue and knows how to  solve it? Thank you. 

[Icey · Accepted solution]

Hi @fanhui3 ,

Please change "#N/A" to "N/A" in your data source excel file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

@fanhui3 

is N/A values good for your data source?

show all power query code for your data source (Advanced Editor)

do not hesitate to give a kudo to useful posts and mark solutions as solution