If you have a DirectQuery fact table in Power BI you can use user-defined aggregations to improve query performance; querying a smaller, summarised copy of your data in an Import mode aggregation ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results