Forum Discussion

michael_knight's avatar
michael_knight
Post Prodigy
5 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
michael_knight's avatar
michael_knight
Post Prodigy
5 years ago

Hi swise001 

 

The screenshot I posted is from Power BI Desktop, and it works fine in that and I'm very happy with the numbers. Once I upload it to the Power BI service, it -1 day for every single record

 

I don't use a formula, I change the datatype with the drop down option in Desktop

 

I use the USERELATIONSHIP function in order to connect the completion date to the date table

swise001's avatar
swise001
Continued Contributor
5 years ago

michael_knight 

 

Is this repeatable with all dates?

 

For example - if you create a second table containing dates - and publish it to the service - does the same -1 occur?

This would be my next steps - try to isolate if the issue is only related to that single column's date structure - or if it is reproducible with other dates. 

 

Is there anyway for you to share a snippet of the Power BI desktop file with that date column in place?