Category Archives: Microsoft Excel 2013

XLPublish Is Here !!!

Posted on September 18, 2017 by Biggus Dickus

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

Posted on October 16, 2016 by Biggus Dickus

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

Posted on August 24, 2016 by Biggus Dickus

OK .. I’m going to try to make this as short as I possibly can. I am sick of docs that do not explain to people how to REALLY accomplish something 😦  … I want this to be different but … Continue reading →

Posted in Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, the Cloud, Uncategorized, VBA | 2 Comments

Tech Support Call From 1985

Posted on June 29, 2016 by Biggus Dickus

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

This post is about the Windows 10 Start Menu Corruption BS ….

Posted on April 13, 2016 by Biggus Dickus

I am going to talk about something that most users of Windows 10 have not run into yet, so most will probably be inclined to just write this post off as irrelevant to them .. Just wait !! This post … Continue reading →

Posted in Access, Access Solutions, Business Intelligence, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, the Cloud, Windows 10, Windows 10 Start Menu | 6 Comments

My Rules For Solution Engagements …

Posted on April 7, 2016 by Biggus Dickus

I’m baaaack … again … I have decided that I just cannot not blog … I have too many thoughts and I sure would hate to see all the knowledge I have accumulated disappear with me into retirement someday (or … Continue reading →

Posted in Access, Access Solutions, Business Intelligence, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, VBA | 3 Comments

My Thoughts On Excel TV

Posted on July 17, 2015 by Biggus Dickus

Earlier this week I appeared on the Excel TV broadcast with Rick Grantham, Jordan Goldmeier and Oz du Soleil …  It was great fun for sure and I hope it was somewhat valuable to the broad Excel community (and even … Continue reading →

Posted in Access, Access Solutions, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA | 8 Comments

Changes In Procurement Practices Are The Death Of Us All …

Posted on June 2, 2015 by Biggus Dickus

Just replied to someone on LinkedIn in a  conversation about Access work getting really thin lately …  Thought my response might be a good blog .. (additions in blue) .. Jeff asked …”Has the market shifted to hiring contract programmers? … Continue reading →

Posted in Access, Access Solutions, Analysis Services, Business Intelligence, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, PowerPivot, Process Automation, Spreadsheets, the Cloud, VBA | 2 Comments

Windows 10 – To Infinity and Beyond !!!

Posted on May 11, 2015 by Biggus Dickus

As I discussed here earlier the following has been officially announced by the MSM: http://www.bbc.com/news/technology-32658340 There are all kinds of implications of this – and one of them is NOT the death of Windows … quite the contrary.  Even if … Continue reading →

Posted in Access, Access Solutions, Cloud, Excel, Excel 2013, Microsoft Access, Microsoft Access 2013, Microsoft Excel 2013, Office 2013, Office Automation, Spreadsheets, the Cloud, VBA | 5 Comments

Microsoft Excel And Azure RemoteApps … How About A Full-Featured Version Of Excel On Every Device?

Posted on April 8, 2015 by Biggus Dickus

I recently posted here about the opportunities for Access Developers in the Azure RemoteApps technology.  I know that it will cost your clients a bit more than the free ride they have been on with Access (some of them for … Continue reading →

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, PowerPivot, Spreadsheets, the Cloud, VBA | Tagged , , , , , | 5 Comments