Forum Discussion

rocketship's avatar
rocketship
Frequent Visitor
5 years ago
Solved

Date Table Hierarchy Issue

    I'm having some date table issues in a new report I'm buiding. I'm seeing this icon I"m not familiar with and I'm not able to create a proper date Hierarchy.    When I create the Hierarch...
  • rocketship's avatar
    rocketship
    5 years ago

    The issue is related to the fact table and the formatting of the date from SQL. Because of an on prem dataset, live connection, I'm not able to use power query to fix. Had to go to database admin to fix.

rocketship's avatar
rocketship
Frequent Visitor
5 years ago

Thanks for the quick responce. Unfortunatly Auto Date/Time was already selected for Time Intelligance in settings. Any other ideas?

 

Thanks,