Skip to main content

    Power BI

    New

    Direct Query

    Vote (25) Share
    Lucy Pyne's profile image

    Lucy Pyne on 27 Jul 2016 22:00:28

    I connected to a SQL database using direct query mode, I would like to be able to pull in data from another source (i.e. excel) to obtain additional data not stored in SQL. Is there a way around this?

    Comments (3)
    Lucy Pyne's profile image Profile Picture

    378025a0 a124-4611-88af-86e236bfb6cb on 05 Jul 2020 22:54:41

    RE: Direct Query

    Please vote here as the same idea has more votes:
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10321215-allow-mixing-direct-query-and-imported-tables-in-a

    Lucy Pyne's profile image Profile Picture

    37fe8ac6 9e08-4189-bc5b-2133d5554294 on 05 Jul 2020 22:52:24

    RE: Direct Query

    This would be one of the most requested feature from POWER BI to have the self service capability .

    Lucy Pyne's profile image Profile Picture

    f0be9879 54fe-410d-acf9-d9472c177e07 on 05 Jul 2020 22:32:28

    RE: Direct Query

    Some slow change lookup data such as retail SKU need to be stored in Excel