In this session we discussed about how to load the data from excel into power Bi -the options associated with this process discussed.
----------------------------------------------------------
Get data from Excel workbook files
-----------------------------------------------------------
Microsoft Excel is one of the most widely used business applications around. It’s also one of the most common ways to get your data into Power BI.
What types of workbooks does Power BI support?
Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB. Some features described in this article are only available in later versions of Excel.
Workbooks with ranges or tables of data
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. 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 with data models
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. Power BI supports all data model properties such as relationships, measures, hierarchies, and KPIs.
--------------------------------------------------------------------------------------------------------------------------------------------
If any one has any questions reach me at - Power BI Training @ 0091-9704077815
--------------------------------------------------------------------------------------------------------------------------------------------
https://powerbiguru.com/contact-us/
Thanks
Srinivas
Working with Excel data in power BI by Srinivas Gorrepati :Power Bi training from Power BI Guru ダッチオーブン | |
| 4 Likes | 4 Dislikes |
| 1,186 views views | 1.14K followers |
| Science & Technology | Upload TimePublished on 4 Apr 2018 |
Không có nhận xét nào:
Đăng nhận xét