Excel has been used with external data for… well, as long as I’ve been using Excel. So why would anyone bother to write a blog post about this given that… Continue reading Using Excel With External Data – What’s the Right Tool?
Tag: Excel
Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint
Using Excel Services, SharePoint users have been able to share workbooks that are connected to back end data since SharePoint 2007. Typically, the connection is made to SQL Server, or… Continue reading Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint
Set Your Data Load Defaults in Power Query
When using Power Query to load data from a data source, the user has three choices as to where that data can be stored. It can go into a worksheet… Continue reading Set Your Data Load Defaults in Power Query
Changes to the Default Data Loading Options in Power Query
This past week, the March 2014 update for Power Query became available. As always, I wasted no time in getting it installed. There are a number of significant new features… Continue reading Changes to the Default Data Loading Options in Power Query
Problems Manually Refreshing Power BI Enabled Workbooks
Office 365 (without Power BI) has supported data refresh for Excel and PowerPivot for some time, and it works well provided that the data source is both in the cloud,… Continue reading Problems Manually Refreshing Power BI Enabled Workbooks