Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Change SUMMARIZE tables so they don't turn the report into a composite report when all the base data comes from Direct Queries.

    Vote (1) Share
    clqLoveSpace's profile image

    clqLoveSpace on 14 May 2020 23:22:27

    It's really annoying that a table created by SUMMARIZE from direct query data will not refresh in sync with the query table. It turns a report into a composite model and we have to schedule refreshes even though all the data is brought in by Direct Query in the first place. Can you implement new logic so that a DAX-created table can support and automatically load Direct Query mode if all its parent data is coming from Direct Query sources?