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.

2 Replies

  • 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

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    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.