Excel is an excellent tool for analyzing data. An analyst can easily connect to and import data, perform analyses, and achieve results quickly. Export to Excel is still one of… Continue reading It’s time to stop using Power Pivot
Tag: Power Pivot
Business Intelligence in SharePoint 2019
The recent availability of the SharePoint 2019 public preview, and the supporting information that accompanies it has clarified the status of Business Intelligence features in SharePoint 2019. This release, with… Continue reading Business Intelligence in SharePoint 2019
Using Excel Files with Power BI Desktop and SharePoint
As discussed in a previous post, Working with Excel Files in the Power BI Service, Excel and Power BI have a rich, complex relationship. Power BI Desktop is the primary… Continue reading Using Excel Files with Power BI Desktop and SharePoint
Working with Excel files in the Power BI Service
Power BI has been able to work with Excel files since it was first introduced. Indeed, it was born from the analytic capabilities in Excel. Users can connect directly to… Continue reading Working with Excel files in the Power BI Service
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