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: Data Management Gateway
Power BI Data Management Gateway 1.2 Changes the Game
Last week, a new version of the Power BI Data Management Gateway was released. If you’re unfamiliar with it, it is the Power BI component that allows for workbooks stored… Continue reading Power BI Data Management Gateway 1.2 Changes the Game
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
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
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