Forum Discussion
Cubes (SSAS) Date Filters and PowerBI
Hello, Our company is starting to use cubes a lot and one of the issues is date filtering. When we connect to the cube in SSAS the date field seems to be treated as string and not an actual field...
Yes, the actual key is a surrogate key called DateDimID. Good suggestion, I'll try this out and get back to you.
The datatype was already a datetime field from the source so I didn't really change the datatype per se, just the properties of the dimensions.
Hi did you find any solutions to this. Dont want 2 fields. Any way to hide one field