Forum Discussion
Aggregation Model Date Dimension Help
I have created an aggregation model where I have a Direct Query for my detailed data and an import for month/year data. Currently I have 2 date dimensions due to this. One by date level and one ...
i found this link and attempted #2 and yet that isn't working. I have manage aggregations pointing to the direct query for that and have joined the new field on the id of the date table. Yet it's not finding the aggregation.
https://community.fabric.microsoft.com/t5/Desktop/Aggregation-by-month-connect-to-date-dimension/td-p/3585937
UPdate, method #2 sort of works. In that the aggregation is now being followed. However, if I drill down and try to do this by date and count # of tickets it summarizes everything onto the first of the month. If I add a detail column it gives me a million record exceeding error. Which seems due to RLS being performed. I'm assumign the RLS being performed later in the process is causing me problems.