cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

 

Carlos_23486846_0-1656680509574.png

 

Thank you

Status: Needs Info

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

Comments
Carlos_23486846
Regular Visitor

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/

Ailsa-msft
Community Support
Status changed to: Needs Info

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