Lydon Solutions

Construction Project Management Software Solutions

Tips from the Field

Tips from the Field: Adding Images to a Power BI Report

Tips from the Field |

Microsoft 365 Power BI is an incredibly powerful reporting tool and is fast becoming the go-to reporting solution in construction. While creating connections to different data sources and building cool reports is relatively straightforward, adding dynamic images is not as simple.

Read on to learn how to add images to your Power BI report.

Two options when adding images to Power BI reports

There are two paths to adding images to a report.

Option 1

Your first option is to insert images directly into the report. This approach is useful if you want to embed a static image into your report, like adding a logo to a project-specific report.

Unfortunately, you need to open Power BI, update the report, and re-publish it to add or edit images.

Note: These embedded images will display when you print a report.

Option 2

Your second option is to link images dynamically from another file location. This approach allows you to connect to images from another file location and display them dynamically in your report.

A good example of this would be a set of project progress photos that are dropped off in a SharePoint image library every month. You could then connect these photos to your report and use a project and time period slicer to display only the images you would like to see in the report.

While this approach provides the most flexibility, since images are read from the image library, the setup in Power BI of the connection is more difficult.

Also, there are a few considerations to be aware of:

  • Viewers must have permission for both the image library and the Power BI report to view the images.
  • Images will not display in Power BI Desktop until you publish the report to Power BI Online.
  • The connected images will not display when you print a report.
Power BI Desktop with both options
  • When images initially display in Power BI, they will appear as small thumbnails, and you will not have many options to format them. You will most likely need to “Get more visuals” and find a third-party image display visual. See the screenshots below for how to do this.

Step 1: Click the three dots and select “Get more visuals” 

Step 2: And then search on images and click on one to add 

So, you might wonder how actually to create a dynamic image connection in your report from SharePoint? There are a bunch of steps to doing this, but I found a great video to get you most of the way there: A little trick for SharePoint Online Images in Power BI.

We hope this blog helps you build out your project status report. If you need a complete reporting solution from building a Power App to collect period data or structuring a Power BI Report that can filter by project and period, you can submit a consultation request here.

Tips from the Field: How to Access Checked-Out Files

Tips from the Field |

Microsoft SharePoint is a powerful document management platform with robust version control tools. However, a frustrating scenario can arise when you go looking for a file that you know is there, but someone checked out the document and then went off on vacation or left the organization. As a result, SharePoint will not let you open or edit the file – and in some cases, you might not even be able to see it. Here is how to restore your access to the file you need.

How to enable document checkout

Being able to check files in and out in SharePoint is a great way to manage updates, avoid conflicts and enforce version control. But this feature is not enabled by default when creating a new library. To turn on document checkout, you need to change the "Require documents to be checked out before they can be edited" option in the document library's versioning settings (see screenshot).

How to recover checked out documents

Problems can arise when someone checks out a document, does not check it back in, and then becomes unavailable (perhaps going on vacation or leaving the organization and having their account disabled). When this happens, the file may not show in your document library views, leading you to think it has disappeared.

The good news is that you can easily check stranded files back in under your account if you have the right permissions. You can do this regardless of whether the account of the person who checked it out is still active or not. Here's how.

  1. Go into the document library settings
  2. Click on "General Settings"
  3. Select "Manage files which have no checked in version"
  1. Under the "Checked Out Files" view, you will see the currently checked out files. Select the files you want to check back in, then click "Take Ownership of Selection" to become the owner.  The file will now show as being checked out to you. You can now open, edit, or check the file back in as appropriate.

Get More Tips and Tricks for Microsoft 365 and SharePoint

Want more tips and tricks for Microsoft 365 and SharePoint delivered to your inbox? Subscribe to our newsletter in the footer below. If you need hands-on help getting the most out of Microsoft technology, check out our Microsoft 365 Managed Services offerings. You can also contact us for a free consultation.

Tips from the Field: List and Document Library Templates

Tips from the Field |

Have you ever wanted to create a standard document library in SharePoint with key columns for the project name, contractor, document types, and owner that you can reuse multiple times or import into another site? You can with SharePoint List and Document Library Templates.

Benefits of List and Document Library Templates in SharePoint

SharePoint’s List and Document Library Templates is a powerful feature that will help speed up site creation. There are many benefits to creating sets of list and library templates that you plan to reuse:

  • Standardize lists and document libraries settings (versions, check in check out, and so on)
  • Standardize lists and document library views.
  • Standardize metadata columns and content types across your content.
  • Include content in the template, such as previously created records, which could be helpful if you are creating an archive, backup, or phase of a project.
  • Reduce errors in rebuilding sites.
  • Accelerate time to build sites with repeatable tasks.
  • Export your list and library templates to other sites.

How to Create a List or Library Template in SharePoint

Creating a list or library template is relatively easy.  Make sure you define a template nomenclature in advance so you can easily determine the latest one to use when replicating. Then follow the steps below.

  1. Once you have created a list or library in SharePoint, go into Settings and click the “Save list as a template” link under the Permissions and Management column.

creating standard document library in SharePoint

2. Fill in the File Name (used when you export), Template Name (what will show in your Site Contents Apps), and a Template Description (a handy way to describe how you will use the template).   Note: make sure to use nomenclature that is consistent and easy to identify.

3. If you want to include the records that are currently in the list or library you created, click “Include Content.”

4. SharePoint will display a confirmation message if the creation step was successful.

5. Once created, your template is now available when you add an app under Site Contents.   You can now use it just like any other app.

Want to do more with Microsoft SharePoint and Office 365?

The Lydon Solutions team knows construction and IT.  Our team can help you keep ahead of your competition by getting the most out of technology solutions like SharePoint and Office 365. Contact us for a free consultation.

And if you need something turnkey, we also offer Construction Viz, a powerful construction project management solution with everything required to manage your construction projects, including document management, dashboards, reports, forms, workflows, and more. Construction Viz is available in the cloud, on-premise, or as à la carte apps deployable in Microsoft Office 365 and SharePoint.

Tips from the Field: Creating Office 365 Groups

Tips from the Field |

In a previous post, we discussed the advantages of Office 365 Groups, which bring all Office 365 productivity apps together so you have an integrated solution to manage your projects.  

Office 365 Groups represent a new way to enable team members to collaborate in a common workspace with a standard set of tools.  You can create an Office 365 Group from Outlook, Yammer, Teams, SharePoint Online, and Planner. What’s unique is that when an Office 365 Group is created, you are automatically provisioned a shared Outlook mailbox and calendar, One Note Notebook, Planner instance, and SharePoint site collection. 

A Team’s Team and Yammer Groups can also be associated with the Office 365 Group. Also, you don’t have to worry about permissions since everyone added to the group automatically gets permissions to the appropriate applications. It’s a quick way to set up a collaboration space with all your favorite tools integrated and accessible in one place.  

Creating an Office 365 Group

So how do you create an Office 365 Group? It’s pretty simple and depends on which Office 365 application you start from. Here are the steps: 

  1.  Create New Group. The method is similar in each application. 

Outlook: 

Navigate to Groups in the left navigation and click “New group,” 

tips1-e1578440233540

Yammer: 

Navigate to Groups in the left navigation and click “Create a group.”  

tips2-e1578440210493

SharePoint, Teams, and Planner: 

When you create a modern site collection in SharePoint, a new Team in Teams, or a new Plan in Planner, an Office 365 Group with the same name will be automatically created. 

2. When you create a new Group, you get a window like this. (The exact display may vary depending on your application.) 

tips3
  • Provide a Group name that is related to the project. 
  • Describe the Group’s purpose. 
  • Select whether the group will be Private or Public. My recommendation is to default to Private since you will probably want to restrict access to the Group. Also, leave the box checked for “Members will receive all group conversations and events in their inboxes." They can stop following this group later if they want to.
  • Under “More settings” are the language preferences. 

3. Add members to your Group. This step allows you to add users who will have access to the applications associated with the Group. 

tips4

4. The Group is created with the associated applications. The new Office Group menus within each application are very similar. (At some point, I expect Microsoft will make them identical.)  You can navigate into Planner, SharePoint, One Note, Yammer, and even Teams from within the Office 365 Group. For comparison purposes, see Outlook and Planner below: 

Outlook: 

tips5

Planner: 

tips6

That’s it. Pretty simple overall. I suggest reading my blog post on Office 365 Groups where I provide some considerations for creating Office 365 Groups.  

Microsoft continues to bring the Office 365 suite of productivity tools together into a cohesive productivity solution. The Office 365 Groups seem to be the first step, and Microsoft’s Fluid Framework will take this even further. Make sure to subscribe to our blog as we’ll update you on developments as they are rolled out.  

Don’t Mess with Default Content Types in SharePoint

Tips from the Field |

Most of our “Tips from the Field” are how-to guides to help novice SharePoint users better support their construction projects. This tip is different because it focuses on avoiding a problem that can have dramatic consequences. In short, don’t mess with the default content types.  Read on to learn why, and also how to properly configure custom content types if necessary.

Changing Default Content Types Can Break Your SharePoint Site

SharePoint’s default content types are the foundation of SharePoint apps, lists, and libraries. Content types define behavior and include various columns by default. SharePoint users who modify default content types can render an entire site unusable if done incorrectly. (Yes, you read that right.)

To illustrate, let’s look at a document library, which includes a “document” content type by default. If you don’t see a similar view, make sure “management of content types” is activated in the advanced settings of your document library.

content types in Sharepoint

If you click on the “Document” hyperlink under the Content Type column, you’ll see the included fields and attributes. For example, the screenshot below shows that the document content type has the “Name” and “Title” fields, and that name is a required field. 

So, whenever you add documents to this library, it will enforce the attributes of the document content type, and “Name” will be a required field (as denoted by a star).

content types in Sharepoint

With the right permissions, you can modify and add to the default content type, which will change the behavior of that specific document library.

So what’s the big deal?  There are several implications for modifying the document content type at the document library (content) level:

  • Library setting vs. content type. Changing the configuration of the library settings can conflict with modifications made to the default document content type.  For example, different columns could become required fields. This can result in documents being automatically checked out or disappearing.
  • Differences between libraries. Unless you drill into the document content types within the document library, you will have no idea why one library works differently than another. On the surface, they can look exactly the same.
  • Content type hierarchy. Document content types with the same name reside at the content hub or site collection. Sites, lists, and libraries inherit default content types from their parents, so behavior cascades from the highest to the lowest level. If you modify a specific app’s default content type at the document library level, any subsequent changes made at the hub or site collection will overwrite the document library content type. So, lists and libraries will be inconsistent.
  • SharePoint software updates. SharePoint software updates, when applied, could overwrite functionality for the default content types.

So, what do you do about it?  Do not modify the default content types. Instead, you can add your own custom content types.

How to Add Custom Content Types

If you are going to use content types, create new ones at the highest level (hub, site collection or site) for reuse and add them to the document library at the content level. If you click on “Add” from the existing site content types, you can select from the existing content types.

content types in Sharepoint

Choose the content type from the Groups and click “Add” to move each type from the left to the right box. Then click “OK.”  For example, see the project documents content type in the image below.

Once you add a new content type to your document library, you can make it the default setting for that library. From that point forward, every time you add a new document to that library it will use your new content type. Alternatively, you can also have your new content type appear as an option when a user clicks the “New” button to add a document. Both of the above methods will ensure the default document content type stays intact and you can easily see when a new one is being used instead of the default, making it easier to troubleshoot any problems.

If you want to know more, ask questions in the comments below.

Managing content types is an important part of using SharePoint for construction management, and one of the many ways Construction Viz makes your job easier. Contact us for a free consultation.

And be sure sign up for our monthly newsletter in the footer below to get our latest blog updates, tips on using Microsoft SharePoint, and other useful info.

Adding Microsoft Power BI to an Office 365 SharePoint Web Page

Tips from the Field |

Microsoft Power BI is a powerful reporting tool for providing dashboards and analytics. This business analytics service, which is offered with Office 365, transforms data into stunning visuals that facilitate fast, informed decision-making, the kind you need to make your construction project a success.

One really cool thing you can do with Power BI is embed your report into Office 365 SharePoint online so that you can share it with your team members. Here are the steps to do this. Publish your report from Power Bi to Office 365. Log into the Power BI app from the Office 365 portal and click on your report from My Workspace.

1. Publish your report from Power Bi to Office 365. Log into the Power BI app from the Office 365 portal and click on your report from My Workspace.

Microsoft Power BI

2. Click “File,” “Embed” in SharePoint Online.

3. Copy the link.

4. Navigate to Office 365 SharePoint Online and create a page (modern Page) that you want to share with your team.

5. Click on the plus sign at the bottom of the page to add a web part.

6. Scroll the available web parts and select Power BI. A new Power BI web part will be added to the page.

7. Click “add report.”

8. Paste the Power BI report link you copied earlier (Step 3) into the Power BI report link.

9. And that’s it. Your report will display in SharePoint.

Do Even More with SharePoint & Power BI using Construction Viz

Construction Viz enables you to leverage all the power of the Power BI data-analytics tool to help you make decisions about your construction project. As a SharePoint-based solution, Construction Viz integrates with Power BI. You don’t have to do any heavy lifting to add sophisticated visual reporting to your construction management toolkit.

We hope you found this information helpful. We encourage you to check out our other Tips from the Field, which feature valuable information for construction project managers. And subscribe to our newsletter in the footer below.