Advertisements

Speaking at SharePoint Saturday Baltimore this Saturday | Oct 20, 2018

Follow @baltsharepoint I’ll be speaking this Saturday at SPS Baltimore (#SPSBMORE). I’ll be presenting my brand new, magical session on content management, archiving and retention for the second time this year. Don’t miss it! SharePoint wizardry for content management, archiving & retention Are your muggles muddying up your servers and site storage with duplicate files,…

Advertisements

Speaking at SharePoint Saturday Kansas City this Saturday | Oct 13, 2018

Follow @SPSKC1 My local SharePoint Saturday, SPS Kansas City, is coming up THIS WEEKEND (#SPSKC). I’ll be speaking about one of my favorite topics – building a modern intranet: Building the Intranet of the Future: Using SharePoint to Empower Collaboration Automation, organization, incredible search capabilities and user interactivity; all things your organization can have in…

Speaking at SharePoint Saturday Denver this Saturday | Oct 6, 2018

Follow @SPSColo I’ll be speaking this Saturday at SPS Denver (aka SPS Colorado) (#SPSColo). I’ll be presenting a brand new, magical session on content management, archiving and retention: SharePoint wizardry for content management, archiving & retention Are your muggles muddying up your servers and site storage with duplicate files, pictures from a 2008 staff party…

How to get a free trial of Office 365 for home, business or enterprise

A free trial of Office 365 is a great idea if you’re:

  • Curious how it could help your team and want to do some testing as a group
  • Wanting hands-on experience with tools you’re interested in using
  • Needing to test something out in a safe, no-consequence zone before applying it to your actual environment
  • Studying for exams 70-346 or 70-347 (I recommend a Business Premium trial)
  • Considering changing licenses

Get a free trial today:

What is the Related() function in Power BI?

RELATED() pulls values from different tables based on relationships established in the relationships tab. This is useful and makes it so we don’t necessarily need to append or merge tables to get the same result.

For example, we can create a new calculated column in our fact table Sales that pulls in related information from two other tables without needing to append or merge tables:

PBIDesktop_2018-09-25_10-32-08

Change the default link type and sharing settings for SharePoint documents

By default when a user chooses to share a document, a selection has already been made to share that document with anonymous access, restricted organizational access or only with specific people (requiring entry of recipients) depending on who set up your tenant. If no changes were made, chances are the links default to anonymous access. A user can change this setting to restrict access before sharing but for newer users in a hurry, it’s likely anonymous links could be being created and shared incidentally because time isn’t being taken to review the alternative options.

Here’s how you, as an administrator, can change the default settings to something more secure without (or with) removing anonymous capabilities.