As I’ve explained many times before, querying SharePoint data directly is a bad idea. The SharePoint data storage mechanisms simply aren’t designed for querying of any scale, hence the lookup… Continue reading Using Power Query with SharePoint Lists and Lookup Fields
Tag: Office 365
Using the SSIS OData Source Connector With SharePoint Online Authentication
Last week, Microsoft released the OData Source for Microsoft SQL Server 2012 . What is it? It allows SQL Server Integration Services (SSIS) to use an OData feed as a… Continue reading Using the SSIS OData Source Connector With SharePoint Online Authentication
How to Refresh Data Models in Office 365 from On Premises Using Nintex Workflow – A Hybrid Approach
One of the viable use cases for Power BI is to provide reporting to a mobile workforce, even when the organization has invested in BI on premises. In this scenario,… Continue reading How to Refresh Data Models in Office 365 from On Premises Using Nintex Workflow – A Hybrid Approach
Business Intelligence in SharePoint and Office 365
At the recent SharePoint Conference 2014, I had the opportunity to be interviewed by Karuana Gatimu of Microsoft IT and Channel 9. The original video can be found on Channel… Continue reading Business Intelligence in SharePoint and Office 365
Scheduled Data Refresh in Power BI
It’s finally here. Quietly, sometime over the past few days, Microsoft updated the Power BI application in Office 365 along with the Data Management Gateway (get it here). Chief among… Continue reading Scheduled Data Refresh in Power BI