Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Direct Query

    Vote (27) 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

    Ananda Kumar 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

    Rajesh 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

    Chris Han 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