Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a sales detail table (Direct Query) and sales agg table (Impot Mode) in the backend DB. Created a Date dimension and Month-Year Dimension in Power BI level (both are on Import Mode). Defined the relationship. Next step I am trying define agreegation on sales agg table but that is complaining "Aggregation tables cannot be on the filtering side of relationships to the other tables that are not agreegation tables"
The end goal is : whenever user will be fetching SAALES_AMT and YEAR, then it should fetch from in-memory, though "
Hi, i have the same error, i see the report error was 2023, but now in PBI desktop april 2025, i have the same error when make the relationships.
i miss something configuration or issue in new versions?
Hi @koushikchandra according to msg error is type of relationship table DIM_MONTH_YEAR and SALES_IMP_HOT, changee it and try agg. Hope this help, kudos appreciated.
Proud to be a Super User!