SharePoint 2016: Failed to create the configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown

In this article, I will solve the below SharePoint 2016 Configuration Wizard issue

Failed to create the configuration database.
An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.


Scenario

Unfortunately, I didn’t have an internet connection on the SharePoint Servers to can install the SharePoint 2016 Prerequisites over the internet automatically.

So I went to install the SharePoint 2016 Prerequisites offline that has been installed properly and the SharePoint installation has been started without any complaint.

Once the SharePoint 2016 installation is finished, I tried to run the SharePoint 2016 Configuration wizard to configure the SharePoint 2016 farm. Continue reading “SharePoint 2016: Failed to create the configuration database. An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown”

Advertisements

No Project web app instances found. Create at least one PWA instance before accessing this page In Project Server 2016

In this article, I will fix the below Project Server 2016 issue

No Project web app instances found. Create at least one PWA instance before accessing this page


Scenario

After creating the PWA 2016 Site Collection, I have tried to browse it, but I got the below error

No Project web app instances found. Create at least one PWA instance before accessing this page

No Project web app instances found. create at least one PWA instance before accessing this page


Cause Continue reading “No Project web app instances found. Create at least one PWA instance before accessing this page In Project Server 2016”

Calculate the Rows Count, Ignoring Filters In Power BI

In this article, I will show How to

Calculate the total rows, Ignoring Filters In Power BI

Calculate the total rows, Ignoring Filters In Power BI


Scenario

In Power BI, I have a “Projects” table as SQL data source, I would like to show

  • The total number of rows, ignoring the filter.
  • The total number of rows, depending on the filter.

As below shown,  Continue reading “Calculate the Rows Count, Ignoring Filters In Power BI”

Count Blank Values In Power BI

In this article, I will show How to

Count Blank (NULL) values In Power BI Chart

Count Null values in Power BI Chart


Scenario

In Power BI, I have a data source from SQL Server Table that contains a field called “Project Status“.

The “Project Status” is not a mandatory field so it may hold a Blank or NULL value.

In Power BI, I have added a chart to show the count of “Project Status” values with the default configuration as below:

  • In Legend: Project Status.
  • In values: Count of Project Status.

Unfortunately, the configured Chart didn’t show the “No Date Items” as shown below

Show items with no data in Power BI

Continue reading “Count Blank Values In Power BI”

Install and Configure Power BI Report Server

In this article, I will show How to

Install and Configure Power BI Report Server Step By Step

Install and Configure Power BI Report Server


What’s the Power BI Report Server?

Continue reading “Install and Configure Power BI Report Server”

Power BI: We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly

In this article, I am going to solve the below issue:

We couldn’t run the report because we couldn’t connect to its data source. The report or data source might not be configured correctly.


Scenario

In Power BI Report Server, although I can browse the report properly in Power BI Desktop.

But when I tried to browse the newly published report from the Power BI Web Portal, I got the below error:

We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly.

We couldn't run the report because we couldn't connect to its data source. The report or data source might not be configured correctly. Continue reading “Power BI: We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly”

SSRS 2016: You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.

In this article, I will solve the below issue in SQL Server Reporting Service 2016

Could not load folder contents
You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.

Reporting Service 2016 - You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.
Applies To

SQL Server Reporting Service 2016.


Steps

Continue reading “SSRS 2016: You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.”