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...
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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you v-deddai1-msft , GilbertQ . I have solved this issue. 

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 

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi Agucho You would need to change your measures to use a date table.

    • Agucho's avatar
      Agucho
      Frequent Visitor
      3 years ago

      Thanks Gilbert,

      I am doing so, already marked my custom date table as "date table" and fixed all the measures containing .[date] formats. 

      So far, so good.

      Then I created a Date Hierarchy (Year, Qarter, Month) in my custom date table in the dataset. Only issue is that I can't get it to show Year, Quarter and Month as before. This is only a "user friendly" problem.

      Any ideas on how to get this as before? I am currently exploring options.

      Thanks!

      Before:

       

       After:

       

      • Agucho's avatar
        Agucho
        Frequent Visitor
        3 years ago

        Hi GilbertQ  I found a workaround to this, taylormade.

        First I created new columns in the custom date table, with:
        QuarterName (Q1, Q2, etc)
        ShortMonthName (Jan, Feb, etc)

        Then sorted the ShortMonthName by the Month (number) column.

        Then created a Date Hierarchy using the previous fields, and renamed them like this:

         

        It is working so far!

        NOTE: forgot to mention in the previous post that I disabled the Automatic Time Date feature from my pbix file.