![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |