Tag Archives: troubleshoot

“Unable to connect” error when accessing SQL database in Power BI Desktop

“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 We encountered an error while trying to connect. Details: “An error happened while reading data from the provider: ‘Could not load file or assembly ‘System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=….. Error message received when trying to get […]

Content and script editor web parts missing in SharePoint

Content and script editor web parts missing in SharePoint

Missing two of your favorite web parts? Don’t fret. Make sure the site collection feature “SharePoint Server Publishing Infrastructure” is activated Make sure the site feature “SharePoint Server Publishing” is activated Still not there? Check “Settings” in the admin center to see if custom scripts are allowed on personal and self-service created sites (allow both). […]

SharePoint calendar all-day events showing as previous day in content search web parts

SharePoint calendar all-day events showing as previous day in content search web parts

Despite your regional settings being correct, all-day events for some reason are using UTC time when they’re stored and are likely showing as the wrong day in content search web parts and similar web parts. Though they look correct as an individual item or on a calendar, the way they’re stored doesn’t acknowledge your regional […]

Solution: “This web site has been configured to disallow page editing with SharePoint Designer.”

Solution: “This web site has been configured to disallow page editing with SharePoint Designer.”

There are three possible causes I’m aware of that you should check if you receive this message: Central admin settings not configured properly Site collection settings not configured properly You’re using a Project Web App (PWA) site template and can only fix this on SharePoint Server I’ll cover the solutions for each in the same […]

How to increase lookup column limit in SharePoint lists

How to increase lookup column limit in SharePoint lists

Lookup columns include workflow status columns, traditional lookup columns to other lists, and person/group columns. This includes the two default people fields “Created by” and “Modified by”. If your list has more than 12 of these, you may receive the following error: “This view cannot be displayed because the number of lookup and workflow status […]

Solution: “The user who attempted to complete the task is not the user to whom the task is assigned”

Solution: “The user who attempted to complete the task is not the user to whom the task is assigned”

You might run into this issue when running task processes in SharePoint Designer. “Reason: The user who attempted to complete the task is not the user to whom the task is assigned.” Assuming the person should actually be able to complete the task, check the following: Make sure the user who was assigned the task […]