ISSUE: Datamart. Can't set table as Date table.

[Carlos_23486846]

Hi.

I am trying to create a Datamart and I'm receiving error messages when I try to set my calendar table as a date table. See error below.

This is an identical model to one I previously built in PowerBI Desktop. It works there, so I don't think there should be any problems with the model. The calendar table does not contain complex Power Query steps. just ingest from a dataflow.

Thank you

[Carlos_23486846]

Text from the image in original post:

Activity ID: 0d60dfff-ca3f-4a0c-a1b0-c5638a1002cb
Request ID: 2e3fcdf3-88b4-b709-0642-1fe68af720e0
Correlation ID: 3cd5b086-d92c-4c4f-b0fb-79225994d3d5
Time: Fri Jul 01 2022 05:59:01 GMT-0700 (Pacific Daylight Time)
Service version: 13.0.18530.39
Client version: 2206.3.12016-train
Cluster URI: https://wabi-us-west2-redirect.analysis.windows.net/

[Anonymous]

Hi @Carlos_23486846 

I have some doubts that when you created a datamart , what is your data source ? How did you set your calendar table as a date table ? I can't tell the cause of the problem from the error message you provided. Can you solve my doubts and give detailed steps and screenshots ?

Best Regards,
Community Support Team _ Ailsa Tao