Category Archives: Office Automation

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

New Feature In XLPublish – Multi Workspace Publish

While XLPublish is already a complete and mature piece of tech at this point, we have added one new feature that you might find useful,  Multi-Workspace Publishing With the introduction of App Workspaces in Power BI (a great way to … Continue reading

Posted in Business Intelligence, Excel, Office Automation, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, XLPublish, XLPublish.com | Leave a comment

Modeloff GTC in New York City – Dec 4-5, 2017

Just a note that I will be in New York on Monday and Tuesday Dec 4 & 5 exhibiting and presenting at: Modeloff GTC New York I will be showing the latest iteration of the XLPublish add-in on exhibit with … Continue reading

Posted in Business Intelligence, Excel, Excel 2013, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, VBA, XLPublish, XLPublish.com | Leave a comment

XLPublish Is Here !!!

Today Personal Logic Associates Inc. is proud to ship XLPublish – our new Add-in for Excel that makes publishing your Excel data in Power BI Easy, Reliable and Repeatable. With XLPublish you can make your current Excel Ranges, Tables, Pivot … Continue reading

Posted in Business Intelligence, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, XLPublish, XLPublish.com | 1 Comment

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

Tech Support Call From 1985

I received THIS request for tech support YESTERDAY … Hi Dick, Would you please tell me what a Code A is and how we fix it. When we try to add soy loads to one of the years we get … Continue reading

Posted in Access, Access Solutions, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, VBA | Leave a comment

How To Change Connection Type In Power Pivot

Every day, day in and day out, the most popular posting I have here is this one: https://dmoffat.wordpress.com/2013/08/21/how-you-can-change-to-another-connection-type-in-powerpivot/ and this one: https://dmoffat.wordpress.com/2013/08/14/building-a-flexible-and-efficient-client-side-powerpivot-solution-in-excel-2013-2/ I personally use these techniques all the time, for years now and it is my standard modus-operandi for … Continue reading

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