Forum Discussion
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 have checked the data type in the warehouse and all is good the relations are good but I still can't see the Date type symbol on my column in power bi desktop and also on power bi in Fabric.
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.
4 Replies
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.That makes sense now although it's a good feature to have but thanks for help.
Because i'm using a semantic model from Fabric there is no Table view in power BI desktop
