Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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.
2 ACCEPTED SOLUTIONS
GilbertQ
Super User
Super User

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?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

v-deddai1-msft
Community Support
Community Support

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

View solution in original post

8 REPLIES 8
v-deddai1-msft
Community Support
Community Support

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
Not applicable

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

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 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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:

Agucho_1-1666771648695.png

 

 After:

Agucho_0-1666771447233.png

 

Agucho
Frequent Visitor

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:

Agucho_0-1666787508562.png

 

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.

Thanks for letting us know!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

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?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors