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.
what is the solution to this issue.
- vanessafvg
Community Champion
I have also been having this issue (only saw this post now), using date.value seems to solve most of my issues around date functionality, does seem a bit silly though that this does this, so i dont think it needs a solution but it does just create unnecessary complexity, unless someone can explain why this is happening?
