Conversão de Tabela para Tabela de Data

[RobsonSampaio]

ultimamente utilizando o mesmo banco de dados, não consigo transformar em modelagem a tabela calendário em uma tabela de data. Apresentando sempre a mesma crítica, conforme abaixo:

[Anonymous]

Hi @RobsonSampaio ,
Wanted to check if your issue has been resolved. If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful. If you have any further questions, feel free to reach out.

[Anonymous]

Hi @RobsonSampaio ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @RobsonSampaio ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[rohit1991]

Hi @RobsonSampaio ,

Power BI requires the Date column to meet all of the following criteria: The column must be of type Date (not DateTime or Text). It should contain no blanks. It must have unique values (no duplicates). The dates must form a continuous range , every day needs to be present without gaps. Even if it worked before, something as simple as a blank or duplicate could break validation.

Once the table is created: Go to Modeling → Mark as Date Table → select the [Date] column from the new table

This will guarantee a clean, valid date structure that Power BI accepts without issues.

If you're still seeing the error: Restart Power BI Desktop.  Go to File > Options > Data Load > Clear Cache. Or delete and reimport the date table. Sometimes it’s just a cache/session glitch — especially if you're working on the same model frequently.

[RobsonSampaio]

Prezado obrigado pelo retorno. Já tentei de tudo não adianta. Eu refaço sempre este projeto para o meu aprendizado, sendo assism, o banco de dados é o mesmo e nunca deu problema. Obrigado mesdmo

[Anonymous]

Hi @RobsonSampaio ,
Thank you @rohit1991 .
Thanks for confirming you've tried all suggestions. Since this used to work with the same setup, it could be an environment or session-related issue especially if you're working in a cloud or Fabric-connected environment. Try clearing the model cache, restarting Power BI Desktop, or even recreating the file from scratch.
Hope this resolve your query. If so,consider accepting it as solution.

Regards,
Pallavi

[RobsonSampaio]

Boa noite . Obrigado pela resposta. Esse ponto que você analisou, já foi verificada e a crítica continua acontecendo

[lbendlin]

A date table must have contiguous dates, without gaps and without duplicates.