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

[Anonymous]

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.

[GilbertQ · Accepted solution]

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 · Accepted solution]

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]

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

[Agucho]

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]

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

[Agucho]

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]

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.

[GilbertQ]

Thanks for letting us know!

[GilbertQ · Accepted solution]

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?