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: Power Query
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
Changes to Data Loading Features in Power Query – May 2014
The Power BI team continues to deliver new features at a rapid pace. The May 2014 release of Power Query is no exception. There are quite a few new features… Continue reading Changes to Data Loading Features in Power Query – May 2014
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
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