Bhawana Rathore – SharePoint & Microsoft Power Platform Tutorials – SPGuides

How to Change Organization Name in Microsoft 365?

Fri, 24 May 2024 07:08:23 +0000

When you want to change the organization name in Microsoft 365, you must be a global administrator. In this Microsoft tutorial, I will explain how to change the organization name in Microsoft 365 using 3 different ways. Such as:

Change the Organization Name in Microsoft 365
How to Change Organization Name in Entra ID
How to Change Organization Name in Azure AD

How to Change Organization Name in Microsoft 365

As a global administrator, you can modify your organization’s profile details, including the organization name, address, phone number, etc.

To change the organization name in Microsoft 365, follow the below-mentioned steps. Such as:

1. Open Microsoft admin center [https://admin.microsoft.com/] and click on the Org settings option under the Settings options.

2. Now, on the Org settings page, click on the Organization Profile tab and click on the Organization information.

3. Finally, you will get the Organization information, such as Name, Street address, Apartment or suite, etc.

4. Now, change the Name of the organization, including all the information, and click on the Save button, as in the screenshot below.

5. Once it is done, you will get the confirmation message [Saved], as shown below.

Output:

This is how we can change the organization name in Microsoft 365.

How to Change Organization Name in Entra ID

Next, I will show you how to change the organization name in Entra ID. In this case, follow the below steps. Such as:

1. On the Microsoft 365 admin center page, select the All admin centers option and click on the Microsoft Entra option.

2. Now, on the Microsoft Entra admin center page, Click on the Overview option and select the Properties section. Here, you will find the organization details, as shown below.

3. Finally, change the organization name and select the Save button.

4. Have a look at the below screenshot for the output.

Output:

This is how we can work with how to change the organization name in Enter ID.

How to Change Organization Name in Azure AD

Finally, I will also show you how to change the organization name in Azure AD. To work around this, follow the below steps.

1. Open the Microsoft Azure portal [https://portal.azure.com/], select left navigation, and click on the MIcrosoft Entra ID option, as shown below.

2. Now, on the Microsoft Entra admin center page, Click on the Overview option and select the Properties section to change the organization name, as shown below.

This way, you can change the organization name in Azure AD.

I trust this Microsoft tutorial is helpful. If you need to change the organization name in Microsoft 365, follow the above three different ways to achieve it.

You may also like the following tutorials:

Bhawana Rathore

Hello Everyone!! I am Bhawana a SharePoint MVP and having about 10+ years of SharePoint experience as well as in .Net technologies. I have worked in all the versions of SharePoint from wss to Office 365. I have good exposure in Customization and Migration using Nintex, Metalogix tools. Now exploring more in SharePoint 2016 Hope here I can contribute and share my knowledge to the fullest. As I believe “There is no wealth like knowledge and no poverty like ignorance”

www.enjoysharepoint.com/author/bhawana/

]]>

Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified.

Mon, 22 Apr 2024 07:58:48 +0000

Recently, I was creating an Asp.Net web application for a SharePoint POC where we wanted to display SharePoint list data using CSOM (Client side object model using C#.Net), but I got an error as: Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified.

The full error looks like the below:

Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified.

Just to give a background, I was creating an asp.net application and add the Microsoft.SharePoint.Client.dll and Microsoft.SharePoint.client.Runtime.dll from NuGet packages.

To resolve this, you can add the “Microsoft.ApplicationInsights.Web” dll from NuGet.

To do so, Right click on References inside Solution Explorer and click on “Manage NuGet Packages” like below:

Then, you can search for “Microsoft.ApplicationInsights.Web” and then click on Install.

But in my case, the dll was already added. So, I need to update the dll. In the same NuGet manager,

Click on the Updates tab, select “Microsft.ApplicationInsights.Web” and then click on Update. This will be updated to the latest version.

Now the error “Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified.” will not come.

Install Microsoft.ApplicationInsights.Web from NuGet Package Manager Console

There is another approach, we can install Microsoft.ApplicationInsights.Web from NuGet Package Manager Console.

From Visual Studio, click on Tools -> NuGet package manager -> Package Manager Console.

Then, in the console, write the below command,

Install-Package Microsoft.ApplicationInsights.Web

To install it into a particular project, then run the below command.

Install-Package Microsoft.ApplicationInsights.Web

Once you click on Enter after writing the above command, it will install Microsoft.ApplicationInsights.Web, and you will not get the error.

Update Microsoft.ApplicationInsights.Web from NuGet Package Manager Console

Suppose you have already installed Microsoft.ApplicationInsights.Web, and still you are getting the above error? Then, you can update Microsoft.ApplicationInsights.Web from NuGet Package Manager Console.

Right-click on the Reference folder and then click on “Manage NuGet Packages…“, then you can search for “Microsoft.ApplicationInsights.Web” and there you can click on Update to the latest version like below:

The error can come in WCF services, windows applications, or web applications. Every time you need to install Microsoft.ApplicationInsights.Web from NuGet Package Manager.

You can also check an error that comes in an asp.net application.

I hope this tutorial will help to resolve the Could not load file or assembly ‘Microsoft.AI.Web or one of its dependencies. The system cannot find the file specified error.

How to Save Excel File to SharePoint?

Sat, 24 Feb 2024 20:57:34 +0000

Do you know how to save an Excel file to SharePoint? Follow this SharePoint Online tutorial to learn how to save an Excel file to SharePoint.

Here, we will see how to export Excel directly into a SharePoint list and export the Excel file to SharePoint using the “Save As” option.

We will also cover how to upload an Excel file into the SharePoint document library.

How to Save Excel File to SharePoint

Here, we will discuss how to save Excel file to SharePoint using different ways. Such as:

Export Excel Directly into a SharePoint List
How to Save Excel File to SharePoint Using the “Save As” Option
Working with Upload an Excel File into the SharePoint Document Library

Export Excel Directly into a SharePoint List

Let’s take a simple scenario: I already have an Excel Sheet named “Customer Details,” and this table contains the below fields.

Column Name	Data Type
Customer ID	Text
Customer Name	Text
Gender	Text
Email	Hyperlink
Country and Area Code	Number
Phone Number	Number
Address	Text

Now, I would like to add this Excel file directly to the SharePoint Online list as in the screenshot below.

To work around this, follow the below-mentioned steps. Such as:

1. Open the Excel file -> Select the Data table -> Choose an Export option, and select the “Export Table to SharePoint List” as shown below.

2. In the next step, it will ask you to provide the respective “SharePoint Site URL Address” and provide the “Name of the list“. Once it is done, click on the Next button like below.

3. In the next step, you will get the names of the columns and respective data types. Then, click on the Finish button.

4. Once you click on the Finish button, it will provide the confirmation window [The table was successfully published…], and click on the Ok button.

Refer to the below screenshot:

5. Now, go to your SharePoint site, where you will get the created SharePoint list [Customer Details] as shown below.

6. Also, you can add a new record in the Excel table, it will be saved in the SharePoint list as well.

This is how to work with exporting Excel directly into a SharePoint list.

How to Save Excel File to SharePoint Using “Save As” Option

Next, I will show you how to save an Excel file to SharePoint using the “Save As” option with a simple example.

Example:

I will also take the above Excel table [Customer Details] for this example. Now, I want to save the Excel file into the SharePoint document library using the “Save As” option, as in the screenshot below.

To achieve it, follow the below steps.

1. Select the Excel table and click on the Save As option -> Select your respective SharePoint site like below.

2. Once you select your site, it will ask you to provide the file name and select the respective document where you want to export, as shown below.

3. Once your Excel file is explored, you can also create a New folder [Provide Name -> Click on Ok button] like below.

4. Now, go to the respective SharePoint document library and select the specific folder [Customer Details] to get the Excel file as in the screenshot below.

This is how to save an Excel file to SharePoint using the “Save As” option.

Upload an Excel File into the SharePoint Document Library

In the last, we will discuss how to upload an Excel into the SharePoint document library with a simple scenario:

Scenario:

I have an Excel Sheet [Customer Details] that is saved on my local device. Now, I would like to add this Excel file to my SharePoint document library.

Refer to the below screenshot:

To do so, follow the below steps.

1. Open your SharePoint document library -> Expand the Upload tab and Select the Files option.

2. Next, it will be redirected to the local device to select the specific Excel file. Then, click on the Open button like below.

3. Finally, it will take a few seconds to retrieve the Excel into the SharePoint document library as in the screenshot below.

This is how to work with the upload an Excel into the SharePoint document library.

Conclusion

Exporting an Excel directly into a SharePoint list option allows you to save the Excel file to the respective SharePoint list.

This SharePoint Online tutorial explained in detail how to save Excel file to SharePoint. Including:

Export Excel Directly into a SharePoint List
How to Save Excel File to SharePoint Using the “Save As” Option
Working with Upload an Excel File into the SharePoint Document Library

You may also like:

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>

SharePoint Document Set vs Folder: Organizing Your Documents Effectively

Wed, 14 Feb 2024 08:03:28 +0000

When managing documents in SharePoint, understanding the difference between a document set and a folder is crucial for efficient content organization. Both help users manage and store documents, but they offer different features and are suitable for various scenarios. In this blog post, we’ll delve into the specifics of SharePoint document sets and folders, helping you decide the best fit for your needs.

Understanding SharePoint Folders

A SharePoint folder is the most basic way to organize content within a document library. Similar to a traditional file system, folders in SharePoint allow users to group files in a central location. They are straightforward containers that enable users to categorize their files, making them easier to find and manage.

However, folders have limitations, especially regarding metadata and searchability. Relying solely on folders can lead to a deep hierarchy that can become cumbersome to navigate.

Exploring SharePoint Document Sets

On the other hand, a document set is a more advanced feature in SharePoint that allows users to group related documents together as a single entity. Document sets extend the capabilities of folders by offering additional features, such as shared metadata, workflows, and versioning across the set.

Document sets are designed to manage grouped content more effectively, making them ideal for project documentation, legal cases, or any scenario where a collection of documents needs to be managed together. They provide a unified interface and experience for managing related documents, which can significantly improve productivity and collaboration.

SharePoint Document Set enables users to group multiple documents supporting a single project or task into a single entity. A Document Set is a group of related documents that can be created in one step and then managed as a single entity.

Technically, the document set is a special content type in the SharePoint term. When we are creating a document set for a document library, we are actually adding a special content type to the document library. Each document set has a special set of attributes, metadata, and object model elements, and each document set has a welcome page, which can also be customized according to the purpose of the document set.

Comparing Features of Folders and Document Sets

Metadata and Content Types

One of the key advantages of document sets in SharePoint is their ability to share common metadata. When you create a document set, you can assign shared metadata, which is automatically applied to all documents within the set. This ensures consistency and makes it easier to search and retrieve content.

SharePoint Folders, in contrast, cannot share metadata across contained documents. Each file within a folder can have its own metadata, but there’s no simple way to enforce consistency without manually updating each item.

Versioning and Workflows

Document sets in SharePoint support versioning for the entire set, meaning you can track and restore changes to the entire collection of documents as a single unit. This is particularly useful when multiple documents are part of a larger process or project.

Folders in SharePoint do not have this capability; versioning in folders applies to individual files rather than the folder as a whole. Workflows can be associated with document sets, allowing for more complex business processes to be automated and applied to the entire set.

Navigation and User Experience

Document sets provide a more streamlined user experience, as they display all the documents in a set within a single view. This can be customized to show important metadata and provide quick access to the documents’ content.

With folders, navigation can become more complex, especially with deep folder hierarchies. Users may have to click through multiple levels to find the documents they need, which can be time-consuming.

Document Set vs. Folder in SharePoint

Here is the summary:

Feature	Document Set	Folder
Metadata	Shared across documents in the set	Individual to each document
Versioning	Applies to the entire document set	Applies to individual files
Workflows	Can be associated with the entire set	Limited to individual files
Navigation	Single view for all documents in the set	Multiple levels of hierarchy
User Experience	Streamlined and customizable	Can become complex with deep hierarchies

Add document sets to a SharePoint document library

In SharePoint, to work with document sets, we need to do the following things:

Activate Document Sets Feature
Add Document Set Content type to document library
Create document sets

Activate SharePoint Document Sets Feature

SharePoint provides document sets as a feature at the site collection level, and by default, the document sets feature is not activated in the SharePoint site collection. So, to work with Document sets, we first need to activate the document set feature, then we need to enable content type, and then we can add documents.

To activate the feature, open your SharePoint site, click on the Settings icon, and then Site Settings. This will open the Site Settings page. Here, click on “Site collection features” under Site Collection Administration. Then, on the Site collection features page, search for the “Document Sets” feature and activate the feature.

Add Document Set Content type to SharePoint document library

Once the feature is activated, we can add the “document sets” content type to the document library in SharePoint.

Then open the SharePoint document library, and in the library settings page, click on Advanced Settings under the General Settings page. Then, in the Advanced Settings page, select the Yes radio button in the “Content Types” section, as shown in the figure below:

Now, in the SharePoint document library Settings page, click “Add from existing site content types” under Content Types.

This will open the Add Content Types page where you can select “Document Set” and then click on Add like below:

Create SharePoint document sets

The document set will be added to the SharePoint document library. Open the document library, and from the Ribbon, click the FILES tab and then click on Document Set like below:

This will open the New Document Set page, provide a Name and Description like below, then Save.

Now the document set looks like below, where you can see All properties of the document set, Edit properties, and add documents inside it.

We can upload documents to a document set like we normally upload documents to a SharePoint document library. You can create a new document, upload existing documents, or drag and drop documents into the document set.

If you open the document library, you will be able to see the document set name, and if you click on that, you will be able to see all the documents you uploaded to the particular document set.

Overall, the SharePoint document library with document sets looks like below:

Conclusion

Choosing between SharePoint document sets and folders depends on your organization’s specific needs. For simple categorization and storage, folders may suffice. However, document sets are the superior choice for more complex scenarios requiring consistent metadata, versioning, and workflows across a set of related documents.

By understanding the differences between these two methods of organizing content, you can make an informed decision that will enhance your team’s productivity and improve document management within your SharePoint environment.

In summary, if you’re looking for a way to manage related documents with shared properties and a unified interface, consider leveraging the power of SharePoint document sets. If your needs are more straightforward and you need to categorize files without additional functionality, then traditional SharePoint folders may be the way to go.

You may also like:

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>

How to Export Power BI Report to Excel?

Tue, 13 Feb 2024 14:05:15 +0000

This Power BI tutorial will discuss different approaches to exporting data from Power BI to Excel.

I recently worked on a Power BI report where I needed to export Power BI data to Excel. I was able to accomplish this task with just three clicks.

This tutorial will explore Power BI export to Excel, how to enable export options in Power BI Desktop, how to export to Excel in Power BI Desktop, and how to export to Excel in Power BI service.

Also, we will discuss how to export data with the current layout, summarized data, and underlying data in the Power BI service.

Power BI Export to Excel

Exporting to Excel from Power BI means taking the data and visuals you’ve created in Power BI and saving them into an Excel file. It lets you have a copy of your Power BI data in a familiar format that is easily editable in Excel. You can further analyze or manipulate the data using Excel’s features.

The image below depicts the Power BI data after it has been exported to Excel.

How to Enable Export Options in Power BI Desktop

You must enable the export option presented in the Power BI Desktop to use the Power BI Export to Excel. To enable the export option, follow the below steps.

1. Open Power BI Desktop. Then click on the File tab.

2. After that, click on Options and settings -> click Options.

3. Select the Report settings which is present under the CURRENT FILE.

Once you select the “Report settings” option, you’ll find three choices under the “Export data.” Then, choose Allow end-users to export summarized data from the Power BI service or Power BI Report Server. Then click OK. Check the screenshot below.

This way, you can enable export options in Power BI Desktop.

How to Export Power BI to Excel?

Now, let’s go through the steps to export Power BI Desktop data to Excel, one by one.

NOTE:
Before exporting Power BI to Excel, it’s essential to create a report in Power BI. If you’re new to Power BI, consider reading a detailed guide on how to create a report in Power BI Desktop?

Here is the report I’m using for this example. I highly recommend creating a report before proceeding further. Check the screenshot below:

Follow the below steps to export Power BI Desktop to Excel:

1. Open the Power BI report you created before in Power BI Desktop.

2. Click on the visual you want to export(In my case, a pie chart). Then, you can see the three dots (…), which are present at the top right corner of the visual. Select Export data.

3. Then choose the location where you want to save the Excel file and Select the Excel File type as CSV. Then click on Save.

4. Afterward, when you open the Excel file on your desktop, you can see the data, similar to the screenshot below.

This way, you can export Power BI to Excel.

Example-2 (Power BI Export Table to Excel):

1. In the Power BI Desktop, select the table visual. Then, you can see the three dots (…), which are present at the top right corner of the visual. Select Export data.

2. Next, select the location where you want to save the Excel file, choose the Excel file type as CSV, and then click on “Save.” Then, open the Excel file on your desktop. You can see the same as the Power BI table visual.

You can easily export the Power BI table to Excel using these steps.

Export Data from Power BI Dashboard

Now, let’s look at how to export data from the Power BI service to Excel.

1. Navigate to the specific dashboard containing the visual you wish to export. In my case, matrix visual. Check in the screenshot below.

2. Select your visual and click on the three dots (…) present at the top right corner of the visual. Then select the Export data option.

3. When you select the Export data option, the window below will appear where you choose which data format to export: Data with the current layout, Summarized data, or Underlying data.

Data with current layout = It means exporting the data in the same layout as you see it in the Power BI report or dashboard, but without any icons, colors, or other formatting you’ve added.
Summarized data = It means exporting the summarized data used to create your Power BI visual.
Underlying data = It means exporting the raw data used to calculate the data in your visual.

Now we see one by one how to export into Excel.

Export Data from Power BI Service to Excel with the Current Layout

Now, we see how to export data from the current layout of the Power BI service to Excel.

1. Select your visual and click on the three dots (…) present at the top right corner of the visual. Then select the Export data option.

2. Next, select Data with current layout. Then click the Export button.

3. The .xlsx file is downloaded to the local system. Then, open it in Excel.

Follow the above steps to export data from the Power BI service to Excel with the current layout.

Export Power BI Service to Excel with Summarized Data

Now, we explore how to export summarized data from the Power BI service to Excel.

1. Select your visual and click on the three dots (…) present at the top right corner of the visual. Then select the Export data option.

2. Next, select Summarized data and select File format as .xlsx. You can choose the .csv file format if you want an Excel file. Then click the Export button.

3. The Excel file is downloaded to the local system. Then, open it in Excel.

This way, you can export summarized data from the Power BI Dashboard to Excel.

How to Export Underlying Data in Power BI Service to Excel

Here, we see how to easily export underlying data in Power BI service to Excel.

Select the visual -> click the three dots (…) -> select the Export data. After that, if you face an error like “The report author turned off this option.” Check the screenshot below.

To solve this error in the Power BI Desktop, go to the Report setting and select Allow end users to export data with current layout, summarized data, and underlying data from the service or Report Server under the Export data. Then click OK.

After that, republish your report or visual.

1. Go to the Power BI service and open the report you publish above. Then Select the visual -> click the three dots (…) -> select the Export data.

2. Next, select Underlying data. Then click the Export button.

3. The Excel file is downloaded to the local system. Then, open it in Excel. You can see the raw data in the Excel file.

You can export underlying data in Power BI service to Excel using this method.

Power BI Export to Excel Limitations

You need permission when you try to export underlying data.
Power BI allows a maximum of 30,000 rows for CSV and 150,000 for Excel to be exported.
Conditional formatting rules applied in Power BI may not transfer to Excel.
When you enable the Show items with no data option, the Underlying data will not work during Exporting.
Calculated fields or measures created in Power BI might not export with the same functionality to Excel.
You can not export more than one visual at a time.

Conclusion

I hope you understand how to export data into Excel in both Power BI Desktop and Power BI Service.

This tutorial taught us Power BI export to Excel, how to enable export options in Power BI Desktop, how to export to Excel in Power BI Desktop, and how to export to Excel in Power BI service.

Additionally, we covered how to export data with the current layout, summarized data, and underlying data in the Power BI service.

You may also like:

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>

Windows Server Appfabric: download error in SharePoint

Thu, 01 Feb 2024 13:49:09 +0000

While I was trying to install SharePoint in Windows Server 2016, I got an error message: “Window Server App Fabric: download error”. The error exactly comes when we run the prerequisitesinstaller.exe file. The error looks like the following:

To overcome this, we have to follow some steps.

Windows Server Appfabric: download error

We can download Windows Server Appfabric offline and can configure app fabric. Follow the below steps:

Step-1: Then we have to download APPFABRIC 1.1 from this MSDN link.

Once downloaded, run the exe file. Then after getting the “Accept License Terms” page, we have to click on “Yes, accept the terms in the license agreement” and then click on Next.

Step 2: In “Customer Experience,” click on “No, I do not want to participate in the program,” which is by default, then click on Next.

Step-3: In Microsoft Update, click on I do not want to use Microsoft Update which is by default. Then click on next.

Step-4: In “features”, check the Runtime and Administration Tools checkboxes. Both need to be checked.

Step-5: In Confirmation, we have to click on Install.

Step-6: Here in progress, we have to wait for some time till installing App fabric 1.1 for the window server is installed.

Step-7: Once the installation over, “AppFabric Server Configuration Wizard” will start automatically like below:

Here, click on Next.

Step-8: In the Configure Hosting Services, also we do not need to change anything. Just click on Next like below:

Then, on the Configure Application page, check the “Start Internet Information Services (IIS) Manager” checkbox like below:

Then click on Finish, and the configuration will be over.

Now, when you run the prerequisitesinstaller.exe again, the error will not come.

Read some SharePoint tutorials:

SharePoint 2016 installation errors
http error 400. the size of the request headers is too long. sharepoint online
Microsoft sync framework runtime v1.0 sp1 (x64) download error SharePoint

I hope this SharePoint tutorial helps us to fix the error Window Server App Fabric: download error.

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>

Microsoft sync framework runtime v1.0 sp1 (x64) download error SharePoint

Thu, 01 Feb 2024 13:37:38 +0000

Recently, when I was trying to install the SharePoint server 2016 in Windows server 2016, when I ran the prerequisites, it gave me the below error, which says “ Microsoft Sync Framework Runtime v 1.0 SP1 (*64): download error” as shown in the given figure.

sharepoint 2016 prerequisites sync framework download error

Microsoft sync framework runtime v1.0 sp1 (x64) download

To solve this problem, we have to download and install Microsoft Sync Framework Runtime v 1.0 SP1 (*64).

First, download Microsoft Sync Framework Runtime v 1.0 SP1 (*64) Setup from this msdn link. And once download over click on the setup file to start the installation. This will show the screenshot below, and then click Next.

microsoft sync framework runtime v1.0 sp1 (x64) download error sharepoint 2016

In the license agreement, select on “I Agree” option and click next.

Microsoft sync framework runtime v1.0 sp1 (x64) download error sharepoint 2016

Here, it will show the “confirm installation” for confirmation and go to next.

Microsoft sync framework runtime v1.0 sp1 (x64): download error

Here the installation will be done after some time.

sharepoint 2013 prerequisites sync framework download error

Once the installation is done, you can again run the SharePoint 2016 prerequisitesinstaller.exe, and this time, you will not get the same error.

Hence, we solved the problem of “Microsoft Sync Framework Runtime v 1.0 SP1 (*64): download error during installation of SharePoint server 2016 by following these several steps, which are mentioned above.

In this SharePoint tutorial, we learned how to fix error, microsoft sync framework runtime v1.0 sp1 (x64) download error while installing SharePoint server 2016.

You may also like:

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>

The list is too large to save as a template. the size of a template cannot exceed 52428800 bytes.

Thu, 01 Feb 2024 12:59:46 +0000

This SharePoint tutorial explains how to solve “the list is too large to save as a template. the size of a template cannot exceed 52428800 bytes” in SharePoint Online or SharePoint on-premise. The error comes while saving a list as a template in SharePoint.

I was trying to save the SharePoint list as a template with content recently. But it gave an error as Sorry, something went wrong. The list is too large to save as a template. The size of a template cannot exceed 52428800 bytes.

The full error message looks like below:

the list is too large to save as a template sharepoint online

The solution will work for any issues below:

the list is too large to save as a template
SharePoint the list is too large to save as a template
increase template size limit SharePoint online
increase maximum size of list template SharePoint 2013
the list is too large to save as a template SharePoint 2013
the list is too large to save as a template SharePoint online
the list is too large to save as a template the size of a template cannot exceed 524288000 bytes
the list is too large to save as a template. the size of a template cannot exceed 52428800 bytes.

the list is too large to save as a template. the size of a template cannot exceed 52428800 bytes.

By default, SharePoint on-premise allows the list template or site template to be a maximum of 50MB.

So if your list size is more than 50MB, then the above error will come. In SharePoint on-premises like SharePoint 2016/2013, we can change the Size from 50MB to more than that.

We can increase it using the stsadm command as well as by using the PowerShell command. The below command will increase the size limit from 50MB to 200MB. The value in the parameter will take in bytes.

Below is the PowerShell command to increase the SharePoint list template size in SharePoint 2013/2016.

Add-PSSnapin Microsoft.SharePoint.Powershell
 $webservice = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
 $webservice.MaxTemplateDocumentSize = 209715200
 $webservice.Update()

The above cmdlets will increase the limit for both list template size as well as site template size. This way we increase the maximum size of the list templates in SharePoint on-premise version.

the list is too large to save as a template the size of a template cannot exceed 52428800 bytes (SharePoint Online)

In SharePoint Online, we can not change the list template size. If you got this error, then you need to make sure whether you want to take the full content or not. Or you can take save the list as a template without content. Or you can remove a few items or documents from the list or document library to make it less than 50MB.

Conclusion

We can not increase the list template size in SharePoint Online. But if you are trying to increase the list template size in SharePoint 2016/2013/2010, we can use PowerShell or STSADM.

I hope this will be helpful in resolving the error; the list is too large to save as a template. the size of a template cannot exceed 52428800 bytes., which comes in SharePoint.

You may also like:

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>

PowerShell get-date [With examples]

Wed, 03 Jan 2024 18:05:48 +0000

In this PowerShell tutorial, I will explain everything about the get-date PowerShell cmdlets with examples. Then I will cover the PowerShell get-date -uformat with examples.

PowerShell get-date

The Get-Date cmdlet in PowerShell is used to get the current date and time. It can also be used to format the output, create a datetime object with a specific date and time, and perform date arithmetic. When you run this command, PowerShell displays the current date and time, including details such as the day of the week, month, day, year, and the time down to the second.

Now, let us check a few usages of Get-Date with examples in PowerShell.

The basic syntax of the Get-Date cmdlet is straightforward:

Get-Date

When you run this command, you’ll see an output similar to this:

03 January 2024 23:20:53

After I executed the PowerShell script using Visual Studio Code, you can see the output in the screenshot below.

One of the most useful features of Get-Date is its ability to format the date and time output. You can use the -Format parameter to specify the format of the date and time.

For example, to display the date in a “Month/Day/Year” format, you can write the script like below:

Get-Date -Format "MM/dd/yyyy"

Once you execute the code using VS code, you will get the output in the screenshot below:

There are numerous format specifiers available, such as:

MM: Month number
dd: Day of the month
yyyy: Year
hh: Hour
mm: Minute
ss: Second

The Get-Date cmdlet allows you to format the date and time using the -Format parameter. You can use standard .NET date and time format specifiers.

Example of a custom format:

Get-Date -Format "yyyy-MM-dd HH:mm:ss"

PowerShell get-date -uformat

The -UFormat parameter in the Get-Date cmdlet allows you to format the date and time output using Unix-like date formatting strings. This is particularly useful when you need to create timestamps for filenames, logs, or when you need to format the date in a specific way for display or processing purposes.

How to Use -UFormat in PowerShell get-date

Using the -UFormat parameter is straightforward. You need to provide a format string that specifies how you want the date and time to be displayed. Here’s the basic syntax:

Get-Date -UFormat ""

The format string consists of special characters representing different date and time components. For example:

%Y – Year as a four-digit number (e.g., 2023)
%m – Month as a two-digit number (e.g., 04)
%d – Day of the month as a two-digit number (e.g., 12)
%H – Hour in 24-hour format (e.g., 14 for 2 PM)
%M – Minute as a two-digit number (e.g., 30)
%S – Second as a two-digit number (e.g., 45)

Let’s look at some examples:

# Get the current date in YYYY-MM-DD format
Get-Date -UFormat "%Y-%m-%d"

# Get the current time in HH:MM:SS format
Get-Date -UFormat "%H:%M:%S"

# Get the current date and time with custom format
Get-Date -UFormat "%Y-%m-%d %H:%M:%S"

Once you execute the PowerShell script using VS code, you can see the output like below:

Practical Examples of get-date -uformat PowerShell

Let us check a few practical examples of get-date -uformat in PowerShell.

Logging: If you’re writing a script that logs events, you might want to prepend the log entries with a timestamp:

$timestamp = Get-Date -UFormat "[%Y-%m-%d %H:%M:%S]"
$logEntry = "$timestamp An event has occurred."
Add-Content -Path "C:\logs\eventlog.txt" -Value $logEntry

Filenames: When creating files with a date-time stamp in their name, you can use -UFormat:

$filename = "backup_" + (Get-Date -UFormat "%Y%m%d%H%M%S") + ".zip"
# This will create a filename like "backup_20230412143045.zip"

Data Processing: When processing data, you might need to convert date formats. For example, converting a date from one format to another for CSV output:

$dateForCsv = Get-Date "2024-04-12 14:30:45" -UFormat "%d/%m/%Y %H:%M:%S"
# Converts to "12/04/2024 14:30:45"

Conclusion

In this PowerShell tutorial, I have explained how to use the get-date cmdlet in PowerShell, especially how to work with PowerShell get-date -uformat with a few real examples.

You may also like:

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>

How to Add Title to Power Bi Dashboard?

Wed, 25 Oct 2023 08:09:10 +0000

Do you want to add a title to a dashboard in Power BI? In this tutorial, I have explained how to add title to Power BI dashboard.

Add Title to Power BI Dashboard

Here, I will show you how to add a Title to the Power BI Dashboard. Below is the Power BI Dashboard screenshot where I will add the Title.

To add the Title to the Power BI Dashboard, Click on the +Add tile option on the top bar of the Power BI Dashboard page.

Once you click on the +Add tile option, It will open the below window. Select the Text box option that helps add text or any custom text to the Power BI Dashboard. Just click on the Next button.

Now, the Add textbox tile will appear where you have to enter the below field values:

Display title and subtitle: Once you put the checkmark to this option, it will display the title and subtitle of this text box. (By default, this option was disabled.)
Title: Provide the title of the text box that you want.
Subtitle: Provide the subtitle of the text box which you want.
Content: Under the Content section, you can change the text font, font size, text color, text alignment, etc. Also, you can describe the dashboard under the Content section.
Set custom link: Check the Set custom link to provide the link type.
Link type: Choose any link type option whether you want to give an External link or link on the dashboard or report in the current workspace.
Dashboard or report to link to: If you enable the link type as ” link on the dashboard or report in the current workspace“, Select any Dashboard or report to link to any existing dashboard which you have on the drop-down.

Click Apply when all the field values are filled, as shown below.

Now you can view your Title, Subtitle, and Content section at the bottom of the Power BI Page, as in the below screenshot.

Conclusion

I hope now you have an idea of how to add a title to the Power BI dashboard. It is easy to add a Title to a dashboard in Power BI.

You may also like:

Power BI Change Data Type of a Column
Export Power BI Reports to Excel
Get Current Month Sales Report using Power BI Measure
Power BI report using People Picker Field

Bhawana Rathore

www.enjoysharepoint.com/author/bhawana/

]]>