Search This Blog

Loading...

Friday, January 6, 2017

Multi Factor Authentication, Conditional Access for Power BI

There is always a discussion on protecting Power BI access, enabling MFA, conditional access etc.
This is very much possible. Please refer this article.
I have attached a PPTwith screenshots of how this works (infact, I have taken it from iGrid’s Azure Subscription)
Using certain configuration, you can even block access for users, when they are not at work.
Infact, you can have such a configuration done for every O365 product.

You would require Azure AD Premium P1 for this and different plans are here: https://www.microsoft.com/en-us/cloud-platform/azure-active-directory-pricing
This could approximately cost $6/user/month.


Saturday, December 17, 2016

Solved: Battery Icon not visible and Power Toggle option disabled in Windows 10

I run Windows 10 Pro and the battery icon disappeared a few days before. When I went into the System Notifications Icons On / Off, the Power Button was disabled and I could not toggle it on.

I then went to Device Manager, Disabled and Re-Enabled couple of options under the Battery Node.

The Battery Icon came again!


Saturday, November 19, 2016

SSRS Installation on Single and Multiple Servers

Please find the below steps for SSRS installation


Single Server Farm Installation
1.       Install SQL Server (Select Reporting Service - SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
3.       Install SharePoint server
4.       Run Install-SPRSService
5.       Run Install-SPRSServiceProxy
6.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
7.       Create SQL Server Reporting Service application from “Manage Service Applications)
1 SQL Server
1 SharePoint Server (APP + WFE)
SQL Server :
1.       Install SQL Server (Select Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
SharePoint Server :
1.       Install SharePoint Server
2.       Using SQL setup media that is used in the SQL server, install Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products) only – only two checkbox has to be selected
3.       DO NOT INSTALL DATBASE ENGINE
4.       Run Install-SPRSService
5.       Run Install-SPRSServiceProxy
6.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
7.       Create SQL Server Reporting Service application from “Manage Service Applications)

Multiple SQL Server + Multiple SharePoint Server
SQL Server Role – Irrespective of no of servers (only if it is clustered)
1.       Install SQL Server (Select Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
SharePoint Application Server Role
1.       Install SharePoint Server with Application role
2.       Using SQL setup media that is used in the SQL server, install Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products) only – only two checkbox has to be selected
3.       DO NOT INSTALL DATBASE ENGINE
4.       Till step 3 do it in all SharePoint App server, and hold for a while and continue the steps in WFE Servers
5.       Run Install-SPRSService
6.       Run Install-SPRSServiceProxy
7.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
8.       Create SQL Server Reporting Service application from “Manage Service Applications)
SharePoint WFE server Role
1.       Install SharePoint Server with WFE Role
2.       Install only the Reporting Services add-in for SharePoint Products only
3.       Continue with STEP 5 in all SharePoint app servers

Saturday, September 17, 2016

SharePoint Online Navigation Enabling Access Denied - Solved with PowerShell

Check this link for resolution:

http://blogs.catapultsystems.com/hmasters/archive/2014/12/11/sharepoint-online-sorry-you-dont-have-access-to-this-page/ 

Saturday, March 19, 2016

New technologies to learn:


  • SharePoint Online 
    • SharePoint Hosted Apps
    • Provider Hosted Apps
    • App Parts
    • SharePoint Online PowerShell
    • Pulling Data from SPO User Profile into SharePoint App Part / Customizations 
    • Hosting a App in the App Store (SharePoint App Store)
    • Custom Authentication (Possible? 
  • MS Office Add-Ins 
  • Workflow Related
    • Creating a drag and drop interface which creates the activities automatically 
  • Services related
    • REST Services
    • Web APIs
    • differences between both
  • SharePoint 2016
    • What is new in features
    • What is new in capacity development 
    • What is new development 
  • .Net Development / Others
    • What is new in VS 2015
    • What is new in latest .Net Framework? 
    • MVC, MVVM
    • Angular JS
    • HTML5, CSS3
    • TFS (Team Foundation Server) - Configuration Management
    • ALM (Application Lifecycle Management)
    • XAMARIN - Cross Platform Mobile Development 
  • BI
    • SQL Server Integration Services
    • SQL Server Analysis Services
    • Power BI
    • Power BI R Script 
    • Predictive Analytics
    • Custom Visuals for Power BI
    • Power BI integration with Tally
  • Dynamics CRM 
    • CRM OOB Features, Configuration
    • CRM Development 
    • CRM Add-In Development
    • CRM Migration 
  • Office 365
    • Exchange Setup, Exchange Migration 
    • DirSync / Azure AD Connect
    • SFB Setup / Migration 
    • Yammer 
    • SharePoint Online 
    • Azure AD
  • Azure
    • Azure Virtual Networks Setup
    • Azure VMs Setup
    • Azure Monitoring
  • Mockup tools
    • Balsamiq

Thursday, March 17, 2016

Power BI Salient Features

PowerBI is certainly raising up the ranks with key differentiators as below:

1.     Updates almost every week from Microsoft
2.     Integration with SSRS 2016
3.     Custom Visuals (www.powerbi.com/visuals) where you can write your own visuals and render your business data on it
4.     Excel Add-In for Power BI (Add your Excel Pivot Tables, Charts into Power BI Dashboards)
5.     PowerPoint Add-In for Power BI (Embed Power BI Visuals into your slides)
6.     Quick Insights Feature
7.     Ever growing content packs (more than 59 as I am writing this)
8.     Third party providers for Content Packs and Connectors like Theobald software
9.     Yammer Embed Option – with the ability to have a live conversation with your colleagues along side a Power BI Dashboard
10.  Video Embed Option into your dashboard
11.  Public Web Embed Option (Ability to embed your live visual inside a web page) – see examples of what iGrid has done: http://tnceo.gov.in/en-in/SitePages/PastElection.aspx - it has 2 links, which has Power BI Dashboards to show election results
12.  Sharing your Dashboard with your customers or partners
13.  Exporting content out of a visual as CSV – for further analysis
14.  Setting alerts on data values on Mobile Apps – for instance, when profitability comes down, your mobile app can immediately alert you and you can take a quick action based on that
15.  R Integration
16.  Azure Machine Learning Integration

17.  Cortana Integration 

Monday, February 8, 2016

Power BI Clarifications - Q&A

  
1.       How can we display Power Bi Visuals inside SharePoint
a.       Can we display the whole Dashboard inside SharePoint Pages
b.       Or can we display just one Visual inside a SharePoint Page using an App?

Response : A new feature has been added to PowerBI.com which is managing of embedded codes in the Settings section of PowerBI. It was added sometime last week only.


2.       How can we provide security for our content so that – the content the dashboard uses only shows the content that the logged in user has permission to
a.       For instance, I have 5 projects (Project 100, 101, 102, 103, 104 for instance) running – we have built a dashboard to show project progress, costing details, resource details etc.
b.       Now when Project Manager 1 of Project 100 comes in, the same dashboard should show data only about Project 100 and not any other Project?
c.       That is how, how does the data security transcend to the project dashboard so that the project dashboard automatically filters and shows only the data authorized for the logged in user
Response :
This scenario is called as dynamic security and is implemented by creating a bridge table which maps each user with the projects he has access to.

Power bi supports dynamic security using analysis services connectors or enterprise gateways.

For more information you can read following articles

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-analysis-services-connector-indepth/

https://msdn.microsoft.com/en-us/library/hh479759.aspx

  
3.       Last, on the licensing
a.       We have a company of 500 users
b.       There is 1 Power BI pro license – for a Developer – who will create the Dashboard (Pulling data from an On-Premise SQL Server) and then Publish to Power BI
c.       Now, he shares this Dashboard to the other 499 users – all of these have only Power BI free license assigned
d.       So is it right to say, we have only 1 Power BI pro license and 499 Power BI free licenses?

Response : What is said is correct. 1 Pro license and 499 free licenses. The first time you share you do get a message that asks you to upgrade to Pro License for free but on clicking cancel you can see the shared dashboard.