Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Make it possible to modify self-generated SQL Query (folded query) by visual components

    Vote (1) Share
    Eddy Orlando Sernaque Curay's profile image

    Eddy Orlando Sernaque Curay on 27 Aug 2020 20:58:10

    Make it possible to modify the statement (or SQL query or folded query) that Power BI auto-generates (especially DirectQuery storage mode) and sends to database to obtain the data set and build a visual component.

    Power Bi generates queries with statements that are often not the most efficient for certain databases (such as Teradata), such as CAST, TOP, etc.

    Reference:
    https://community.powerbi.com/t5/Desktop/Modify-self-generated-SQL-Query-by-visual-components/m-p/1330162#M574488