Unable to mark table as date table

[dslanovic]

Hi everybody.

I've a problem trying to mark a table as date table.

Steps I've followed:

1) Create a new blank report

2) Add a table with this expression: CALENDARIO = CALENDAR(DATE(2000,1,1),DATE(2050,12,31))

3) Trying to "mark as date table". And get the following error: Unable to finish validation. Refresh the page or try again later.

What I'm doing wrong?

Regards

Damian.

[DallasBaba]

@dslanovic I followed your steps and was able to create and mark "CALENDARIO" as a datetable.

You can close and relaunch your PBIX file, then try the process again. Use the Table view to create a new date table and mark 

I hope this help.

[lbendlin]

Not enough memory?  Can you try this after you rebooted your PC?

[dslanovic]

I tried both suggestions: close/open the pbix file, restarted de PC, but no look, the error still there...

[lbendlin]

Which Power BI Desktop version are you using?

See attached.

[dslanovic]

Version: 2.137.952.0 32-bit (octubre de 2024)

Windows 10 Pro 22H2

[lbendlin]

Any particular reason for using the 32 bit version?

[dslanovic]

Yes. Have a 32 bits ODBC datasource that handles a connection to a 32 bits DBMS. There is no posibilities to migrate it to 64 bits arquitecture

[lbendlin]

did my sample file work?

[dslanovic]

Mmhhhhh... I opened it and saw the table marked as date table. Then I uncheked it. And then I tried to check it back and the error appears...

[lbendlin]

maybe a bug in the 32bit version?  Can you roll back to an older version?

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

[dslanovic]

May be, can't tell you. This is a fresh installation.

Also, this is a blank report, there is no older version...

[dslanovic]

Sorry, I misunderstood. You mean an older version of Power BI. I'll try

[dslanovic]

Once removed the latest version, I installed the one of June 2024:

Release: June 2024

Product Version: 2.130.930.0 (24.06) (x86)

OS Version: Microsoft Windows NT 10.0.19045.0 (x64 es-ES)

And I successfully mark a table as date table

So yes, it seems to be a bug...

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[dslanovic]

No, I don't have a Pro license. I'm just downloaded Power BI Desktop and trying to learn a bit...

[dslanovic]

Done.

Unable to mark a table as date table - Microsoft Fabric Community