This way, when creating reports in Power BI, you’ll see named tables and columns in the Fields pane, making it much easier to visualize your data.
Workbooks can contain a data model with one or more tables of data loaded into it by using linked tables, Power Query (Get & Transform in Excel 2016), or Power Pivot.
Manual data refresh, which you initiate from the Power Pivot window, is handled by the local in-memory instance of Analysis Services.
If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see You can use the tools in the Power Pivot window to discover when the data was last refreshed.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site.
Some features described in this article are only available in later versions of Excel.
If your workbook has simple worksheets with ranges of data, to get the most out of your data in Power BI, be sure to format those ranges as tables.