Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Report error in PowerBI Service -Please update the visual with fields that exist in the dataset

Hello,

 

I have published a report which contains a date table defined locally, in PowerBI. A user is complaining that for a filter which contains a field from the date table the following error is received: 

Unrecognized fields in this visual
We are not able to identify the following fields: LocalDateTable_98f179a2-1c0b-46b5-9047-3435b4c8ce20. Please update the visual with fields that exist in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
 
For some users it works and also in the desktop version of the report. Has anyone encountered this? Thank you.
Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago
    Hi there

    From the error it appears tat the column being used is one of the automatic DateTime tables that are created.

    if you can have a look in your PBIX and possibly turn off the auto date time tables?
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    >>We are not able to identify the following fields: LocalDateTable_98f179a2-1c0b-46b5-9047-3435b4c8ce20. Please update the visual with fields that exist in the dataset.

     

    The field was likely deleted or renamed. You can remove the broken field from the visual, add a different field, and repin it.

     

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

     

    Best Regards,

    Dedmon Dai

8 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    From the error it appears tat the column being used is one of the automatic DateTime tables that are created.

    if you can have a look in your PBIX and possibly turn off the auto date time tables?
  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    >>We are not able to identify the following fields: LocalDateTable_98f179a2-1c0b-46b5-9047-3435b4c8ce20. Please update the visual with fields that exist in the dataset.

     

    The field was likely deleted or renamed. You can remove the broken field from the visual, add a different field, and repin it.

     

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

     

    Best Regards,

    Dedmon Dai

      • Agucho's avatar
        Agucho
        Frequent Visitor
        3 years ago

        Hi there, I'm having same issue. But I am afraid to deactivate the Automatic TimeDate feature, as many of my measures include them.

        How did you solve it?
        Thanks!
        GilbertQ v-deddai1-msft