Forum Discussion

michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
6 years ago

Time/Date Problem when publishing to Power BI Service

Hi,   I've got a problem with my Date/Time when publishing to PBI Service   This dataset I've got is used to show the completions in the business. I have a Completion Date and I converted it from...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi michael_knight - Glad you got this worked out; I also enquired and there are some reports we have built for one of our customers which is using data from Dynamics 365 but we are not seeing this issue. 

 

I think you should still open a ticket with Microsoft to look into this. 🙂

 

Also curious to know - did you try the calculated column approach - did that work as expected? 

michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
6 years ago

Well this is the really the only time I've seen this issue. Most of the date data we use in Dynamics 365 has Time and Date, but for this instance it's only a date so maybe that's where the issue lies. I'll contact Microsoft anyway and see if it's an issue

 

I didn't get to trying the calculated column appoach, that was going to be the 2nd thing I tried today but thank god the first thing worked! 

 

Thank for very much for your help, it was much appreicated!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    michael_knight  - Great! happy to help!