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
Tag: Power Query
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
Append Multiple Tables in Power Query
Power Query transformations can be very powerful, but they only work on one data source at a time. Sometimes data providers will only provide their data in discrete chunks, like… Continue reading Append Multiple Tables in Power Query
Delete a Shared Power Query in Power BI
One of the very compelling new features in Power BI is the ability to share a query. Essentially what happens is that a user will build up a Power Query… Continue reading Delete a Shared Power Query in Power BI
Power Pivot Updates to Excel 2013 – November 2013
Did you notice the update to Power Pivot in Excel 2013? Did you know that one was available? Neither did I until I heard about it 2 weeks ago. It… Continue reading Power Pivot Updates to Excel 2013 – November 2013