Data updating excel
Power BI supports importing or connecting to workbooks created in Excel 2007 and later.
Workbooks must be saved as or file type and be under 1 GB.
The Excel files have the query uploaded as data model.
If you use Excel to connect to an external data source, once your workbook is in Power BI, you can create reports and dashboards based on data from that connected data source.* Refresh is not supported for OData feeds connected to and queried from Power Pivot.When using an OData feed as a data source, use Power Query. Typically this will be an issue connected with a gateway.I’m seeing a lot of referral traffic to this post searching for Excel 2010.If you’re simply looking for where you define or modify named ranges in Excel 2010 (as one commenter indicated in response to an earlier version of this update), it’s on the Formulas tab in the Defined Names area — Name Manager.