Category Archives: Cloud

Excel Client Is Not Going Away … Business Reporting Needs It.

Business Reporting For Today I am always thinking a lot about the entire Business Reporting environment.  In fact I have done this constantly now for about 40 years, actually.  While I started as a “Real” person” in a “Real” industry … Continue reading

Posted in Business Intelligence, Cloud, Excel, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, Process Automation, Self-Service BI, Spreadsheets, Uncategorized, VBA, XLPublish, XLPublish.com | Leave a comment

Excel Pivot Tables or Power BI Matrix ? – Use Both With XLPublish

  Let’s start by just looking at these two “Tables”: Excel Pivot Table: Power BI Matrix Visualization   The Same? Look pretty much the same, eh? Well to the Viewer they are, but for the person distributing this report there … Continue reading

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Hierarchies, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Self-Service BI, Spreadsheets, the Cloud, Uncategorized, VBA, XLPublish, XLPublish.com | Leave a comment

Self-Service BI Anyone? Your Excel Models with XLPublish and Power BI Offer You That Today !

Brutal Editorial Honesty: This post is intended to convince you to try the XLPublish Add-In for Excel in your work and in your organization. Please read on … Pre-Apology: Here we go … a loong posting that is effectively a … Continue reading

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Self-Service BI, Spreadsheets, the Cloud, XLPublish, XLPublish.com | Tagged | Leave a comment

XLPublish Is Almost Here !

    This is a heads-up about the imminent release of the new XLPublish add-in written by myself and David Hoppe. If you go to our Website ( xlpublish.com )  there is an explanation of what this is. We will … Continue reading

Posted in Business Intelligence, Cloud, Excel, Excel 2013, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Spreadsheets, the Cloud, XLPublish, XLPublish.com | 3 Comments

How To Really Publish Excel Data To Power BI … Part Deux (amended again)

It has been brought to my attention that  the formatting I chose for my Blog post on this makes for a difficult to copy and paste the code I listed into an Excel module without significant effort (like fixing doub;t-quotes, … Continue reading

Posted in Business Intelligence, Cloud, Excel, Office 2013, Power BI, Power BI Desktop, PowerPivot, Spreadsheets, the Cloud, Uncategorized, VBA | 8 Comments

How To Really Publish Excel Data To Power BI … Part III

OK .. Let’s go … Part III … !! In this post I will try to explain how (and especially how not) to get your Excel data into Power BI Desktop in a way that will allow you to schedule refreshes … Continue reading

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, the Cloud, Uncategorized, VBA | Tagged , | 4 Comments

How To Really Publish Excel Data To Power BI … Part Deux (amended)

Just a quick note for those that looked at and perhaps tried out the code in the post of a couple of weeks ago ( https://dmoffat.wordpress.com/2016/09/29/how-to-really-publish-excel-data-to-power-bi-part-deux/)  .   I have made a very small but very important change to the … Continue reading

Posted in Business Intelligence, Cloud, Excel, Excel 2013, Office 2013, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, the Cloud, Uncategorized, VBA | Leave a comment