Forum Discussion

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

I can't find a problem with your setup (apart from the fact that you don't have a Dates table)

 

 

What's the issue?

tkramer's avatar
tkramer
Icon for Advocate I rankAdvocate I
3 years ago

You 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. 

    • tkramer's avatar
      tkramer
      Icon for Advocate I rankAdvocate I
      3 years ago

      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