By Dhruvin Shah
Power BI and SharePoint are products with their own distinct capabilities, advantages and usefulness within business. Power BI being a suite of data analytics tools that provide insight into any organisation’s reporting data. Power BI allows businesses to connect hundreds of data sources, then simplify data visualisation, and potentially evoke ad hoc analysis. SharePoint is a web-based collaborative platform that integrates with Microsoft Office, primarily a document management system, which is highly configurable and variable organisational uses.
From our experience at Cielo Costa working with clients, we have observed that organisations require integration with both products: SharePoint (SharePoint Online and SharePoint On-Premise), end users or organisations can integrate Power BI reports within SharePoint Online or On-Premise.
Last year Microsoft introduced Power BI web part for SharePoint Online users and for On-Premise versions of SharePoint which they have updated Reporting Services Report Viewer Web part. We have observed that clients were engaged by using their Power BI content within the SharePoint platform and have continually benefited from this programmatic relationship.
Microsoft have a clear and concise road map for Power BI and SharePoint:
Users can integrate Power BI with latest release of SharePoint Server 2019 and SharePoint Online. With Power BI Premium, customers have full support of Paginated report (.rdl), Excel workbooks and Power BI reports.
With the latest update of Power BI, users can easily prepare reports based on the tables available from their Excel spreadsheet or csv files stored via SharePoint Online. End users can select files and open in Power BI to prepare fast and integral visualisations of their reporting data. On top of the extended visualisation capability, users can also ensure updates are reflected in the report automatically, also within the original linked data source.
Part of the road map, Power BI have improved their On-Premise Report server functionality by expanding features like Bookmark and Selection pan from Power BI Desktop features to Power BI Report Server. With the July 2018 Power BI release of PowerShell APIs for the developers and administrators enabling easy management of BI content. For an example, within a large organisation an administrator can manage BI content using Power BI admin centre. With the Power BI PowerShell new possibilities are unlocked for administrators that go beyond what’s currently available in the Power BI Admin Portal. Administrator can manage Reports, Workspace and data set using PowerShell commands.
Microsoft have added recently new features within Power BI:
Incremental Refresh: Instead of refreshing an entire data set, premium users can refresh the data from where it was last refreshed.
Support of Aggregations for Larger data sets: increasing performance and scale-ability of the query performance over a big data.
Report Level Tool tips: enhances end user experience by providing report page or customised tool tip when end user hovers over any report.
Bookmark: Bookmarks in Power BI capture the currently configured view of a report page, including filtering and the state of visuals. Users can also create a collection of bookmarks, arrange them in the order they wish, and represent the story of the report to the end user.
Selection Pane: By combining the Selection Pane feature with Bookmark Pane the features become very useful. For every bookmark in a bookmark pane, Power BI provides one selection pane. Performing a slideshow with the Power BI Desktop, unnecessary visuals can then be hidden with a click to focus on other specific visuals.
Every month Microsoft releases new Power BI features with end user and developer advantages. Refer to the following timeline chart indicating Power BI features and their release month.
In Report Server, Microsoft have supported claims-based authentication which enable systems and applications to authenticate users without requiring the user to disclose additional personal information, such as a social security number or date of birth, that are perhaps more than necessary. Microsoft will also support ADFS and Azure Active Directory support which allow users single sign-on across to the system.
Microsoft supports Power BI and SharePoint integration not only for desktop, it supports mobile platforms such as Android, iOS and Windows. Microsoft has released their mobile updates every month to improve this user experience.
Cielo Costa are a dedicated team of Microsoft Office 365 and Power BI experts that have helped deploy and integrate Office 365 and Power BI solutions within businesses. Refer to Cielo Costa’s case studies to see how Cielo Costa can potentially help your business benefit from Office 365 and the multitude of features that assist business efficiency and success.
In May 2018, SharePoint Conference in Las Vegas Microsoft announced their vision and proposed a timeline for the SharePoint Server 2019:
We will identify the new features released in SharePoint 2019 and how it is possible to utilise these features to improve business processes. The current business climate has been changed, organisations expect their employees to be more collaborative across their working networks and including their own devices without any barriers. Organisations thrive on collaboration, communication, and productivity solutions that are both cost-effective and flexible,
SharePoint Server (SPS) 2019 is designed to help business achieve new levels of reliability and performance, delivering features and capabilities that simplify administration, protect communications and information, and empower users to work across multiple devices and multiple screens.
SharePoint Server 2019 is the next-generation server product, building on SharePoint Server 2016 and investments in Microsoft Office 365. The three-major areas of focus for SharePoint Server 2019 are – Modern User Experience (same as SharePoint Online), Engagement across multiple touch points, robust scale, security and compliance capabilities that meet growing demands.
At Cielo Costa we have observed our clients whom are many legal and finance organisations that do not prefer to utilise cloud capabilities due to security concerns and prefer the system On-Premise solution provided by Microsoft. SharePoint 2019 provides a hybrid SharePoint environment which allows businesses to store sensitive information within their own On-Premise environment and that allows other information to go within cloud storage. We can identify that “Hybrid is just not meant to bring your business to the cloud but to bring cloud to your business”. If a business is looking for the technology where their employees can work together within a collaborative manner, hybrid environment to use Office 365 products, no-code and low-code applications then SharePoint Server 2019 takes the next step with the new capabilities to build new business solutions.
Exploring the new features and capabilities offered by SPS 2019:
Like SharePoint Online, SPS 2019 will allow users to create Modern Communication sites which allow user to use stunning and responsive templates available in Office 365.
Fast site creation:
Compared to older version of SharePoint, creation of the Site Collections and sites is very faster.
Increased storage file size in SharePoint document library: With SPS 2019 users can upload maximum file size 15 GB which was 10 GB in SP 2016.
Modern Lists and Libraries:
SPS 2019 supports Modern List and libraries which increase end users experience.
Modern Sharing Experience:
Users can feel modern sharing experience which is already available in Office 365.
Modern Site Pages, web parts and authoring.
Modern Search experience:
When user type anything they have auto suggestion in search which saves end users time. Office 365 already have this feature. Now, SPS 2019 users can also experience modern search experience.
Modern Team site:
Creation of Modern team site is possible with the new version of SPS 2019.
SharePoint using modern IIS APIs (IIS 7+): SP2016 uses IIS 6 APIs.
With SPS 2019 onwards it uses IIS 7+ APIs. The reason is, if you want to integrate any other third-party APIs which uses IIS 7, it is possible with SPS 2019.
SharePoint Home Page:
It’s a great feature which is supported with SPS 2019 which allow users unified access to all the sites—online and on-premises. Navigation become very easy with SharePoint home Page.
SMTP Authentication for sending email:
All the communications are secured and protected, removing the need for anonymous relays as with previous versions of SharePoint.
File Synchronisation with One Drive Sync Client:
Users can quickly access their documents and any information that they choose to sync from their SharePoint sites, no matter where
they are located.
File Path limit increased to 400 characters.
Allow # and % in file name.
New PowerShell cmdlets for User Profile Sync, SP Application credential key and Content database.
New SharePoint Health Analyzer Rule.
Improvement in Recycle Bin Restore function.
Sharing Email Template.
Telemetry Privacy Experience.
Suite Navigation and App Launcher Improvement.
Additional Documentation Link in Central Admin.
New OneDrive for Business (ODFB) and SharePoint App.
Send Email support for Access Service 2013.
Accessibility of Visio Services.
With the new release of SharePoint Server 2019, Microsoft also suggested migration approaches from the older SharePoint environment. It is possible to perform migration from SharePoint 2016 to SharePoint 2019, however a point to note is for older versions of SharePoint like SP2013 first need to migrate SP 2016 and then SP2019.
Investing in the solution which provides reliability and choice, SharePoint Server 2019 provides flexibility to tailor the deployment based on any unique business need, at now lower costs. Cielo Costa are the forefront of implementation of Office 365 SharePoint capabilities, with a team of dedicated consultants and developers who assist businesses on-boarding and effectively using SharePoint throughout their organisation.
Cielo Costa provides future proof Microsoft SharePoint and Office 365 suite specific solutions for any organisation, which are designed by our senior and experienced developers and Microsoft solution architects.Read More