You can preview the contents of the database objects by clicking on them. Now you should see the data structures in your data source.Type your Username and Password in the respective fields and click. If your data source is password-protected, Power BI will prompt you for user credentials. If you would like to enter a SQL statement to narrow down the returned results, click the Advanced options arrow, which expands the dialog box, and type or paste your SQL statement.In the From ODBC dialog box, expand the Data Source Name (DSN) drop-down list and select the previously configured DSN for SQL Server.Select the Other category in the Get Data dialog box, then select ODBC.Run Power BI Desktop and click Get Data.It is assumed that you have already installed and configured a DSN for ODBC driver for SQL Server. This tutorial explores how to connect to SQL Server and import data into Power BI Desktop using an ODBC driver. To connect Power BI to a data source such as SQL Server, you can use a corresponding ODBC driver. Power BI is a popular business intelligence solution that is comprised of services, apps, and connectors that allow you to pull raw data from various sources and create meaningful reports. Importing SQL Server Data into Power BI Through an ODBC Connection
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |