No other connectors support query folding if you use a native database query. Query folding while using a native database query is limited to the PostgreSQL connector only. Connectorīefore using native database query, you should be aware of the limitations and issues that you may meet. The following Power Query connectors support native database queries. Shape the data as you prefer, then select Apply & Close to save the changes and import the data.Ĭonnectors that support native database queries If the connection is established, the result data is returned in the Power Query Editor. If you don't have access to the data source (both Server and Database), you'll see a prompt to request access to the server and database (if access-request information is specified in Power BI for the data source). Select an appropriate authentication mode, and continue. If this is the first time you're connecting to this server, you'll see a prompt to select the authentication mode to connect to the database. Under Advanced options, select the SQL statement field and paste or enter your native database query, then select OK. Specify the Server and Database where you want to import data from using native database query. Select the SQL Server database option in the connector selection. The procedure is similar in all other databases with native database query that Power Query supports.Ĭonnect to a SQL Server database using Power Query. In the example below, you'll import data from a SQL Server database using a native database query entered in the SQL statement text box. Power Query enables you to specify your native database query in a text box under Advanced options when connecting to a database. For more information, see Native database query security. If you run a native database query written by another user, you will be prompted to ensure that you're aware of the queries that will be evaluated with your credentials.
However, Power Query does not guarantee that the query will not affect the database. One intent of native database queries is to be non-side effecting.