Relationship of Time dimension table and FACT SQL table not connecting correctly

I have an issue with my Time Dimension table in my SQL reports.  I am relating "Time" in the Dimension table to the "CreateTime" in the Fact table.  When I use any of the fields from the Time dimension table, such as "Hour", there are thousands of rows considered blank (shown below).  However, there should be no rows blank, as this is my FACT table with IDs, and every row in the table has a "CreateTime". 

To further troubleshoot the issue, I copied my SQL table into an XLXS file.  No transformations were made at all on the XLXS file so both tables are identical… but the XLXS file worked.

The only transformations that were made on the SQL table was separating the "CreateDate" into two columns (adding one column with Time only, and extracting the original with Date only).  

I need to be able to run this report from the server, but the Time dimension table will not work correctly when connecting to SQL.  This is an Import, not direct query.  I am using the Time Dimension table from Radicad.

Both sides of the relationship are Data type, "Time".  Changing these columns to type Text does not seem to work for me either.  

Here is the link to the PBIX file. 

Is there a better way to separate the original column in SQL (with both date and time) into two columns?  Do I need to approach this differently because this is a SQL table? 

I would love if someone would take a shot at figuring this out.  Thank you!