If your Excel workbook connects to an external data source, once your workbook is in Power BI, you can create reports and dashboards based on data from that connected source. Workbooks with connections to external data sources For example, a user who signs in to Power BI with a account can't share an Excel workbook with a user who signs in with a account. You can't share workbooks with data models across Power BI tenants. Power BI supports all data model properties, such as relationships, measures, hierarchies, and key progress indicators (KPIs). Workbooks with data modelsĪ workbook can contain a data model that has one or more tables of data loaded into it by using linked tables, Power Query, Get & Transform in Excel, or Power Pivot. When you create reports in Power BI, the named tables and columns in the Fields pane make it much easier to visualize your data.
If your workbook has simple worksheets with ranges of data, be sure to format those ranges as tables to get the most out of your data in Power BI.
Some features this article describes are available only in later versions of Excel. Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Types of workbooks that Power BI supports Microsoft Excel is one of the most widely used business applications and one of the most common ways to get data into Power BI.
