Selection Pane Features In Power BI

In the previous “Bookmarks Pane Preview feature” article, we have explored the bookmarks feature that introduced in Power BI October 2017 update.

In this article, we will continue exploring another new amazing reporting feature that is the Selection Pane.


Selection Pane

Selection Pane is a new reporting feature that announced in Power BI October 2017 update.

It’s an amazing feature specifically for complex Power BI reports with many overlapping objects. it lists all the visualization parts in the current report page and allows you to hide and show these parts as you prefer.

Power BI Selection Pane Continue reading “Selection Pane Features In Power BI”

Advertisements

Bookmarks Pane Feature In Power BI

In this article, I will explore the Bookmarks Pane Preview feature that introduced in Power BI October 2017 update.

Bookmarking preview Feature in Power BI


What’s Bookmarks Pane Feature?

Bookmarks Pane is a new preview feature that announced in Power BI October 2017 update.

  • It’s a powerful way to save and share out your insights.
  • It lets you save interesting states as part of your report.
  • It works as a report navigation for your report.
  • It helps you to organize and make presentations of your report.

How to use Bookmarks Pane in Power BI?

By default, the Bookmarks Pane is not available because of it’s still a preview feature.

Bookmarking (preview) In Power BI

To enable any Preview features in Power BI, you should do the following: Continue reading “Bookmarks Pane Feature In Power BI”

Project Server 2016: Get The Enterprise Custom Fields

In this article, we will explain How to

Get the Enterprise Custom Fields In Project Server 2016 Database.


Scenario

In Project Server 2016/2013, In some cases, you may need to export the Enterprise Custom Fields to Excel.

but unfortunately, there is no export option in the Enterprise Custom Fields page as shown below.

Get the Enterprise Custom Fields From Project Server 2016 Database

In this case, one of the available workarounds is retrieving these data from the Project Server Database as the following:


Continue reading “Project Server 2016: Get The Enterprise Custom Fields”

Power BI: Calculate The Project Status In Project Server

In this article, I will explain

How to Calculate The Project Status In Project Server based on the Project Start and Finish Date In Power BI?

Power BI: Calculate The Project Status In Project Server Continue reading “Power BI: Calculate The Project Status In Project Server”

SQL Server: Get the Detailed Information Via SERVERPROPERTY

In this article, we will explain

  • How to get the SQL Server Instance Information using “SERVERPROPERTY”?
  • How to get the SQL Server Instance Information remotely?

What’s the SERVERPROPERTY?

SERVERPROPERTY is a System Defined function used to return the SQL Server Instance Information.

SERVERPROPERTY Syntax

SERVERPROPERTY ('propertyname')

propertyname is one of the following values.

  • MachineName.
  • ComputerNamePhysicalNetBIOS.
  • ServerName.
  • InstanceName.
  • InstanceDefaultDataPath.
  • InstanceDefaultLogPath.
  • Edition.
  • EditionID.
  • EngineEdition.
  • ProductBuild.
  • ProductBuildType.
  • ProductLevel.
  • ProductMajorVersion.
  • ProductMinorVersion.
  • ProductUpdateLevel.
  • ProductVersion.
  • BuildClrVersion.
  • Collation.
  • LCID.
  • IsSingleUser.
  • IsIntegratedSecurityOnly.
  • IsHadrEnabled.
  • HadrManagerStatus.
  • IsAdvancedAnalyticsInstalled.
  • IsClustered.
  • IsFullTextInstalled.
  • ProcessID.

Continue reading “SQL Server: Get the Detailed Information Via SERVERPROPERTY”

SharePoint 2016: Show a List From Parent Site In Sub Site

In this article, I will Show

How to display a SharePoint list from Parent site in Sub Site?

Scenario

In SharePoint 2016, I have a list in the parent site, I would like to show this list inside a page in the subsite.

So that when adding a new item to this list from the subsite, it should also be listed in the same original list in the parent site and vice versa.

Note: You can use the same steps to display a SharePoint list from subsite in parent site.

Continue reading “SharePoint 2016: Show a List From Parent Site In Sub Site”