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
Category: Power BI
Don’t Update Your Power Query After Building a Model
Power Query can be a very powerful data acquisition and transformation tool, and Power Pivot is great for modifying imported models. While it isn’t always crystal clear where to perform… Continue reading Don’t Update Your Power Query After Building a Model
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
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