Forum Discussion
Help with Aggregations and Composite models.
Hi v-piga-msft
My imported table whas the one with aggregated data, same for all the dimensions.
The detail table was the one I was trying to DirectQuery only when needed.
Anyway I finally found the solution. It was a mix of things, first I needed to use the snowflake approach and then use DUAL Storage for the dimensions.
Now it's working fine.Thank you for your response!
Resident RockstarHi Anonymous ,
I still have a little confused about your requirement.
What I was expectig is that when I used dim_site.site_group in any visual, PBI used imported data and if I used dim_site.site then make a DirectQuery over Redshift. It didn't work because PBI always throws a DirectQuery when using this dimension.
What do you mean "use imported data" and "throws a DirectQuery "? Could you explain your desired in more details?
In addition, which table is your impoted table?
Best Regards,
Cherry
Hi v-piga-msft
My imported table whas the one with aggregated data, same for all the dimensions.
The detail table was the one I was trying to DirectQuery only when needed.
Anyway I finally found the solution. It was a mix of things, first I needed to use the snowflake approach and then use DUAL Storage for the dimensions.
Now it's working fine.
Thank you for your response!
- v-piga-msft
Hi Anonymous ,
Glad to hear the issue is solved. I will mark your reply as an answer to close this thread.
Best Regards,
Cherry