Skip to main content

    Power BI

    New

    When referencing another query as a Source, Stop PBI pulling all the data in again! Pointless!

    Vote (23) Share
    Lloyd Jefferies's profile image

    Lloyd Jefferies on 09 Oct 2015 22:48:40

    Every time I reference a previous query as a Source, Power BI will execute that same query and pull in the data again and again for each of the sub queries, surely this is not efficient!

    E.g.
    Source = #"My Parent Query"

    Comments (3)
    Lloyd Jefferies's profile image Profile Picture

    8597baa1 647c-4869-9aa1-91e2da88946b on 05 Jul 2020 22:38:24

    RE: When referencing another query as a Source, Stop PBI pulling all the data in again! Pointless!

    See/up-vote my related requirement: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17709121-allow-me-to-control-order-in-which-queries-load

    Lloyd Jefferies's profile image Profile Picture

    8ea2e74a d5d9-4b9e-b499-a720a12450a9 on 05 Jul 2020 22:35:58

    RE: When referencing another query as a Source, Stop PBI pulling all the data in again! Pointless!

    Any solution for this problem?

    Lloyd Jefferies's profile image Profile Picture

    664aa5dd 14ff-4a2d-a8c3-a119dcb97fe2 on 05 Jul 2020 22:26:59

    RE: When referencing another query as a Source, Stop PBI pulling all the data in again! Pointless!

    It's more than not efficient, it's a killer when dealing with Odata feeds coming from SharePoint for example.