To load the SQL Server data into Power BI for analysis, select the needed table and click Load.Each solution has its issues: Virtual machine with Windows - slows your Mac Windows as 2nd system - it sucks to switch between them Windows on some kind of machine that you connect to via MS remote - it is slow, shortcuts are hard to use Bossie 6 mo. You can preview the contents of the database objects by clicking on them. groundbreaking Power Suite, which consists of Power Pivot, Power Query, and Power BI. True is there is no way to run PBI perfectly and comfortably on Mac. 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

How to run powerbi on mac