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...
- Open Power BI desktop and select Get Data from the opening screen:
- On the Get Data ...
Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
