Forum Discussion

fanhui3's avatar
fanhui3
Icon for Helper I rankHelper I
6 years ago
Solved

Data not detected suddenly

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.    ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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