Top 10 posts of 2019 on

In keeping with a tradition I started last year, I’m sharing the top 10 posts of 2019. Blogging is one of my favorite ways to share with the community (and, admittedly, document things I might forget otherwise). It’s been a pleasure and privilege to have this platform – thank you for reading.

The following includes the ‘Top 10’ most popular posts by views published in 2019:

Microsoft Surface Pro 4 “plugged in, not charging”
Alas, I reached a day where I thought I was done with my Surface. It powered on when plugged in
Read more.
Open a SharePoint Library in Windows Explorer and save it to Quick Access
If you can’t sync a library, or prefer not to, you can pin the web location of a SharePoint form, media,
Read more.
“Unable to connect” error when accessing SQL database in Power BI Desktop
When attempting to access a SQL server/database in Power BI, you might get the following error message: Unable to connect
Read more.
Add a new OneNote notebook to a SharePoint site
If your SharePoint site doesn’t currently have a notebook (most likely stored by default in “Site Assets”), you can add
Read more.
MS-100 & MS-101 Exam Study Guides
Update 10/14/2019: My MS-101 exam guide is now available for pre-order. Also, the courses previously listed below are no longer
Read more.
Flow now supports multiple condition controls for advanced if/then scenarios within a single step
Say goodbye to nested if/then statements in Flow taking up fourteen monitor widths. Flow now supports nested if/then statements all
Read more.
Add a print button to SharePoint list items
One of my more popular requests is an easier way to print list items (either to PDF or paper). Using
Read more.
Power BI refresh error “could not load file or assembly…provided impersonation level is invalid”
Short version Run Power BI Desktop as administrator before opening the report. Explanation/Scenario Recently, when opening a report from Power
Read more.
Export SharePoint group membership names and email addresses to Excel
Before we start, if you’re just wanting to email all members of the group you can “select all” then choose
Read more.
Add or subtract hours from date/time values in Power BI using M formula in Power Query Editor
Previously, I shared how to transform date/time values in Power BI using DAX. But I’m working on building more using
Read more.

Interested in more? Check out the archives for all previous posts:

And if my blog has been useful to you this past year, join the mailing list for weekly updates when there’s new content and consider donating to help defray the cost of keeping the site up.

Support our Community

Help support this site, the Lawrence SharePoint User Group, and community content and events.

Personal Info

Donation Total: $5.00

One Reply to “Top 10 posts of 2019 on”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.