Power BI: HTTP Error 503. The service is unavailable

 

After configuring the Power BI Report Server, If you have tried to browse the Power BI Portal URL, you may get this error “HTTP Error 503. The service is unavailable.“

In Power BI Report Server, this issue "HTTP Error 503 The service is unavailable" almost because of one of the below reasons 

1. The PowerBI Report Server service is stopped. 
2. The PowerBI Report Server service Account is disabled or its password expired 
3. The PowerBI Report Server service account is not configured properly. 
4. The Power BI Report Server is not configured properly.

The Solution is

Start PowerBI Report Server Service

1. Open run and type "Services.msc" and then ok

2. Search for PowerBI Report Server.

3. Make sure that the service account that runs the PowerBI Report Server service is the same account that you have provided during configuring the service account in Report Server Configuration.

4. Restart/Start the service if it was stopped

Note!

If you got a login failure error, try to provide the credentials for the service account again and make sure that the service account password is not expired and it's not disabled!

Project Server : Invalid object name "pjrep.MSP_EpmProject_UserView"

Information!

---

By default, the PWA database has user views for projects, tasks, and assignments. After installing the updates, the content database stopped showing these user views. In the below screen of the content database, you can see there is no user view as “pjrep.MSP_EpmProject_UserView“, and other user views related to tasks and assignments are also missing

The Missing Views "pjrep.MSP_EpmProject_UserView" in Project Server 2016 Database and maybe there are other views which are end name with "_UserView" that are related to Tasks, Risks, TimeSheet, Resources, and Assignment ..etc as below

How to find out the issue

I have SSRS integrated mode reports that read data from the default reporting views in Project Server 2016 database, Suddenly these reports stopped working for no reason! So, After investigating the issue by checking the datasets of these reports and I found out that the "pjrep.MSP_EpmProject_UserView" is missing as below

It’s a bug in Project Server 2016, The reason one of the following

1. You may have changed for custom fields and there's an issue during the Regenerate because those views are always updated and regenerate with any change in the structure for the Assets project such as tasks Fields, resources Fields, custom fields,Risk Fields ...etc 
2.  You have configured a new Project Server 2016 farm that it’s a build number less than 16.0.4639.1001 (Jan CU 2018). 
3. You have patched the current Project Server 2016 farm with a new CU that is older than Jan CU 2018. 
4. You have performed a migration from Project Server 2013 to Project Server 2016

Solution No1 (Almost Reason)

1- Run the Repair Script below

Script!

---

Repair-SPProjectWebInstance -RepairRule 7

2- check the ULS log to debug the issue. Here’s the screen of that log:

3-Looking at the log, I found that the problem existed in the store procedure – "MSP_Epm_GenerateAllMultiValueAssociationViews".In the below screen, you can see the highlighted line causing the problem:

I changed that line in the store procedure to fix the issue. Here’s what I replaced it with-

Script!

---

CF_INDEX int IDENTITY (1,1)

I then re-run the same repair command. And as you can see, this time the status showed "Succeeded" and check the views

---

Solution No2

you have to make rollback in case if there is any update on the project structure (Custom Fields)

---

Solution No3

you have to download the last patch to keep your environment up to date and then run the Configuration Wizard

---

Notes!

---

• Run the Sharepoint Configuration Wizard after all fixes installed!
• It’s not recommended to install SharePoint update on the production environment until tested on dev/test environment.
• Perform a full backup before starting the update process because you can’t rollback the Cumulative Update Installation.

SSRS : How to Install SSRS and Configure IT Step by Step (Video)

By the below, you will learn how to install SSRS step by step to prepare it to get start and build your reports,
Below,it's the first lecture in SSRS course which is transfare how to install SSRS and configure it

Software requirement!

You can download SSRS Package from Microsoft. click here

Power BI: How to Edit SQL Query In Power BI step by step

 Able to update the existing SQL statement, you have to follow the below Steps :

You are Open to DashBoard Power BI Desktop

1- go to Query Editor Home>>Transform Data >> Transform Data

2- Open Query Setting   On the Left side you will fine the query List, Select which one you want to edit

3- Open Query Setting   On the Left side >> Query Setting >> Select the Source

4-Click on the Setting icon gear beside the Source to edit the Query Source

5-it will open SQL Server database settings would be shown, you can edit your SQL statement as you prefer

6- Then Close & Apply to effect on your Dashboard

Power BI: Loading Data From Folder

 Open up PowerBI Desktop and click on the Get Data button and select All on the left side.  Click on the item labeled Folder and click Connect to continue

 Click OK to continue. Upon opening that folder location you will be presented with the multiple files.  Click Edit to edit the query

Edit Query for Folder Load

Now you are in the Query Editor.  This is where the fancy query editing will work to our advantage.  We could load all the data into one large query.  However, depending on the size of your data sets or how you want to report your data this may not always be desirable.  Instead, you may only want data from April, then May when the new data is sent next month.

Note:  When using PowerBI desktop it is a good practice to name the files  beginning with a YYYY-MM-DD file name.  This makes it really easy when sorting and ingesting information into PowerBI.  I have used other columns of information such as Date Accessed or Date Created before but have gotten inconsistent results as these dates can change depending on when a file was moved or copied from one place to another.

Click the drop down next to Name and sort the files in Sort Descending.

This places the files with the most recent file at the top of the list.

Next click on the Keep Rows button on the Home ribbon, select Keep Top Rows.

Enter the number 1 when the popup appears.  Click OK to continue.

Keep Top Rows Menu

Now you’ll notice you have only one file selected which is our latest file from April.  Click the Load File button found in the Content column.

Load File Button

We have completed the activities in the Query Editor and can now load the data.  Click Close & Apply found on the Home ribbon.  All our April data has loaded.  by making a simple table we can now see all the data that was just loaded.

Loaded Data from April

Now we will remove some data from our desktop folder labeled monthly data.  Open the folder on the desktop labeled Monthly Data and delete the filed labeled 2016-04-01 April.  You should now have a folder labeled Monthly Data with only two files in it, one for Feb and one for March.

Two Files Left

Return back to Power BI Desktop and click the Refresh button on the Home ribbon.  Notice now how all our data has changed.  We are now looking at the March data because it is the most recent file in our folder based on the file name.

March Data Load

To verify this we open the query editor (Click the Edit Queries on the Home ribbon).  Click Refresh Preview on the Home ribbon and finally select the Applied Step called Kept First Rows.  This will reveal the month of March as our data source.

Now, every time you add a new file to our folder and refresh PowerBI the latest file (based on the naming convention we talked about earlier) will always be loaded.

Note: This method works great when your data source is coming from an automated system.  The file format must always be the same for this to work reliability.  If the file naming convention changes, or the number of columns or location of those columns changes then the query will most likely fail.

Good luck and thanks for following along.

EPM: How To activate Project Server Subscription Edition, 2019, or 2016

1- Open the SharePoint Management Shell as Administrator.

2- Verify that you have the following memberships:

• securityadmin fixed the server role on the SQL Server instance.
• db_owner fixed database role on all databases that are to be updated.
• Local Administrators group on the server on which you are running the PowerShell cmdlets

3-From the PowerShell command prompt, type the following syntax to enable Project Server Subscription Edition, 2019, or 2016:

Script!

---

Enable-ProjectServerLicense -Key <LicenseKey>

Check for a Project Server Service Application

• Project Server runs as a service application in SharePoint Server, so the first thing to do is check to see if you already have a Project Server Service Application configured.
• In the SharePoint Central Administration website, under Application Management, click Manage service applications.

Check the service applications list for a Project Server Service Application. 

SSRS: Keep headers visible when scrolling through a paginated report

To prevent row and column labels from scrolling out of view after rendering a paginated report, you can freeze the row or column headings.,

1- On the design surface, click anywhere in the table to display static members, as well as groups, in the grouping pane.

The Row Groups pane displays the hierarchical static and dynamic members for the row groups hierarchy, and the Column groups pane shows a similar display for the column groups hierarchy.

2- On the right side of the grouping pane, click the down arrow, and then click Advanced Mode.

3- Click the static member (row or column) that you want to remain visible while scrolling. The Properties pane displays the Tablix Member properties.

4-In the Properties pane set FixedData to True.

5-Repeat this for as many adjacent members as you want to keep visible while scrolling.

6-Preview the report.