Forum Discussion
Creating DateTime relationship, epoch time
Hi, I'm new to powerBI and I just pulled my historical weatherstation data from Azure to powerBI and now I'm trying to figure out how to make DateTime relation. Data was orginally organized by ep...
Hi Niko,
Please try these steps.
1. Delete the relationship;
2. Add a column in "Data table":
PureDate = [Date].[date]
3. Create the relationship.
Best Regards!
Dale
Hi vanessafvg and v-jiascu-msft I created this puredate column and a many to one relationship between them ( Dates[puredate} and Data[date] ) but it didn't solve the problem. Then I also tried to put DateTime type only to date type (on both tables) as Vanessa said, but only thing that this seemed to affect was that I can not anymore see the time in visualisation table on Data[Date] section as in snapshot below.
-Niko