Forum Discussion

A_monged's avatar
A_monged
Frequent Visitor
1 year ago
Solved

PowerBI does not recognize date column as date from Fabric Warehouse Semantic Model

Power BI does not recognize the date column as a date from the Fabric Warehouse Semantic Model, which prevents me from the Date Hierarchy option! anyone faced this issue or have a workaround  1- I ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,Corey_M ,thanks for your concern about this issue.

    Your answer is excellent!
    And I would like to share some additional solutions below.
    Hello,A_monged .I am glad to help you.
    You mentioned that there is no table mode in the left mode of power bi desktop after you connect, so I assume that the connection mode you are using is direct query and the problem you are experiencing is a known limitation.
    This is my test.

    When I choose Direct Query mode:There is no  data  hierarchy.

    When I  Choose Import mode:Date columns are recognized as date types and a hierarchy exists


    If you are connecting to a semantic model in a warehouse in Direct Query connection mode, the inability to display hierarchies for date data is a known limitation of Direct Query, as you can see in the following documentation when you select Connections settings (Learn more about DirectQuery):

    URL:
    Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn
     

    Alternative: If you need to use the Direct Query connection mode and need to use hierarchies, you need to create your own date field hierarchies, or if you can use the import connection mode, I would recommend using the import mode.
    This is a similar issue to yours, hope it helps
    URL:
    Fabric - date dimension and hierarchies - Microsoft Fabric Community

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.