O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding data to Power BI reports

Power BI can currently connect to a wide variety of data sources. Your reports begin by connecting to the data you want to explore and visualize. For example, you can connect to file data sources like Excel, csv, txt or xml file types. You can also connect databases like SQL Server, Oracle, MySQL, PostgresSQL or Hadoop HDFS. In addition, you can get data from Azure datastores such as HDInsight, SQL Data Warehouse, and DocumentDB. In this recipe you will connect Power BI to the SQL Server Analysis Services Tabular model.

How to do it...

  1. Open Power BI desktop and select Get Data from the opening screen:

    How to do it...

  2. On the Get Data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required