Monthly Archives: May 2016

How To Change Data Sources Dynamically In Excel With Power Query

Posted on May 11, 2016 by Biggus Dickus

My Crow Eating Exercise This past week I asked on this blog whether anyone out there was using the technique I wrote about years ago for dynamically changing the Source Connections for Power Pivot Tables in Excel.  I have noticed … Continue reading →

Posted in Business Intelligence, Excel, Excel 2013, Office 2013, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Spreadsheets, VBA | 12 Comments

How To Change Connection Type In Power Pivot

Posted on May 9, 2016 by Biggus Dickus

Every day, day in and day out, the most popular posting I have here is this one: How You Can Change To Another Connection Type In PowerPivot and this one: Building a Flexible and Efficient Client-Side PowerPivot Solution in Excel 2013 I … Continue reading →

Posted in Excel, Excel 2013, Office Automation, OLAP, Power BI, Power BI Desktop, PowerPivot, Process Automation, Spreadsheets, Uncategorized | 19 Comments

Is Power BI For Real ?

Posted on May 5, 2016 by Biggus Dickus

Thought of the day … I have been messing around with Power BI for a while now and while it “looks” great and does “good demo” I’m finding it almost impossible to build anything that I can rely on  .. … Continue reading →

Posted in Analysis Services, Business Intelligence, Cloud, Excel 2013, Microsoft Access, Office Automation, OLAP, Power BI, Power BI Desktop, PowerPivot, Process Automation, Spreadsheets, the Cloud | Tagged , | 15 Comments