Forum Discussion
Aggregation Table - Direct Query
Hi Anonymous ,
I'm sorry for misunderstanding aggregation tables earlier, aggregated table is an import table.
For reports that import connection mode, if you only need to refresh the data on desktop, refer to Refresh a table in Power BI Desktop | Cittabase .
If you need to always have the latest report open on Power BI Service, you can configure scheduled refresh on the report, refer to Configure scheduled refresh - Power BI | Microsoft Learn.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Thanks. On my model, I have a measure (SUM of Sales) using this agg table
The number is correct as long as the user is not selecting "Today". because its always showing ytd's data when selecing "Today"
Which means the agg table only works when report using auto refresh?
Hi Anonymous ,
I'm sorry for misunderstanding aggregation tables earlier, aggregated table is an import table.
For reports that import connection mode, if you only need to refresh the data on desktop, refer to Refresh a table in Power BI Desktop | Cittabase .
If you need to always have the latest report open on Power BI Service, you can configure scheduled refresh on the report, refer to Configure scheduled refresh - Power BI | Microsoft Learn.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thanks for your clear explaination