Forum Discussion
Understanding Agg tables
Your comment actually did help, problem seems to just be down to curly braces { 🤔😵 }. I have never really noticed nor cared before that they are added around the Id text values for some reason by DirectQuery: Direct Query adding curly brackets to Test GUID Fi...
Since the Agg table is in Import mode it's ProjectId values lack the curly braces. So any query hitting the Agg table gets no matches for that relationship (queries on the Fact table that don't hit the agg table use the Fact table Ids which still have braces and so work fine)
Solution is adding braces to the Agg table ProjectId (or setting up the Agg in DQ mode but who would want that?)
Would appreciate any further info as this soaked up a lot of time even though the fix is a simple one. Is this just a bug or is there a good reason for the additional characters?
So that generally means that there are non-matching records in relationships. Not sure how else to help.
- All the ProjectIDs have a match across the tables, the visuals work (slowly) without the agg table setup.
(for my sanity triple checked via copying the columns to Excel to confirm all 1M match in the original table and all 100k in the agg)Your comment actually did help, problem seems to just be down to curly braces { 🤔😵 }. I have never really noticed nor cared before that they are added around the Id text values for some reason by DirectQuery: Direct Query adding curly brackets to Test GUID Fi...
Since the Agg table is in Import mode it's ProjectId values lack the curly braces. So any query hitting the Agg table gets no matches for that relationship (queries on the Fact table that don't hit the agg table use the Fact table Ids which still have braces and so work fine)
Solution is adding braces to the Agg table ProjectId (or setting up the Agg in DQ mode but who would want that?)
Would appreciate any further info as this soaked up a lot of time even though the fix is a simple one. Is this just a bug or is there a good reason for the additional characters?