Forum Discussion
How to use Aggregations and Dual Mode
As it turns out, most answers about this topic can be found here:
https://docs.microsoft.com/en-us/power-bi/desktop-aggregations
Hi,
Thanks for your reply. Could you please explain what you mean by "The aggregation table is generated by power bi" and how this can be accomplished?
I understand the reasons for using aggregations, my dataset is actually rather large, several GB in size, so using DirectQuery the visuals on the report take between 12 and 15 seconds to refresh (sometimes longer). This makes the user experience terrible, since everytime filters or slicers are used the user has to wait too long before all filters are applied.
I don't want to upload the whole dataset to the PowerBI Service as it's too big and eventually the limit would be reached, so I am sure aggregations would solve my problem (given the data to upload would be a fraction of the original dataset).
Could you possibly explain how this can be done?
Thanks
As it turns out, most answers about this topic can be found here:
https://docs.microsoft.com/en-us/power-bi/desktop-aggregations