Forum Discussion
Advocate IRelationship of Time dimension table and FACT SQL table not connecting correctly
Advocate IYou are looking at the time dimension table related to the XLXS file. That is not the issue. The issue is when I am connecting the time dimension table to the SQL table. I posted a screenshot of the two different tables above.
I am wondering if anyone has any idea why there are so many blank rows when connecting to the SQL table.
Super UserThe reason is that your SQL timestamp includes milliseconds.
See attached for a fix.
- tkramer
Great! That makes sense. I saw you used the TIMEVALUE funciton in DAX to create the column, but is there a way I could do this in Power Query without having milliseconds??
I don't see milliseconds in the Time column in Power Query, so I'm not sure how to remove them.
In my actual published report, I settled for creating a DAX Time column from each Timestamp from SQL in my tables. It works, but I am wanting to do everything in Power Query if I can for simplicity. It seems like the DAX created columns all connect perfectly, but using the columns with Extracting/Inserting Time in Power Query do not suffice.
Thank you Ibendlin