Search This Blog


Saturday, September 17, 2016

SharePoint Online Navigation Enabling Access Denied - Solved with PowerShell

Check this link for resolution: 

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 ( 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: - 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 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

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.

Monday, January 4, 2016

Understanding SharePoint Share Option at Site and Document Levels

The Pre-Conditions to enable External Sharing is that, External Sharing must be turned on for that Particular Site Collection. It can be turned on at the tenant level by the Office 365 Admin and then separately can turn on or off for every Site Collection. 

It is important to understand the below scenarios, when Share Option is clicked at the Site Level: 
  • When you are logged in as a User with Full Control Permissions Or you are present in the Owners Group, you can share your Site with both Internal Users as well as External Users; When such a User shares, he also will an option to select one out of 3 permissions levels: Owner, Edit or Read - so accordingly, the Owner user can assign permissions to any of these 3 permission categories. 
  • When you are logged in as a User with Contribute Permissions (Or you are present in the Members group), you can share your Site with both Internal Users as well as External Users). A Member user cannot select the Permission category for the Invited user. The user by default gets Member permissions only. 
  • When you are logged in as a User with Read Permissions (Or you are present in the Visitors group), you can share your Site with Internal Users, but the Permissions request are only sent to the Site Owner. The Site Owner then has to login, go to Site Settings -> Site Permissions -> Click on View Permissions Requests and Pending Invitations and then Approve or Decline the request. Once Approved, then, the respective User invited by the Visitor User will get the required permissions (Member / Contribute level and the Admin can change it after Approving also). A User in the Visitors group however cannot invite External Users                                                                                                                                                                                     External User Invitations also expire in 7 days.                                                                                   
 When a single document is shared, then Get a Link option appears (this does not appear when Site level Sharing is done) and behaves as below: 
  • When a Full Control or Member user shares this, then, he / she gets an option to send a link for both View as well as Edit 
  • When a Member user shares the document, then he / she gets an option to send a link only for View 

Saturday, November 21, 2015

Sharing in SharePoint 2013 - Explained well 

Friday, November 20, 2015

What’s new in Office 2016 for developers

As you’ve read, the new Office is here and for developers, this is an exciting time! The ability to insert add-ins into your documents, call new Office.js APIS, launch task panes inside your Office clients and run commands directly from the ribbon increases the productivity of your entire team! Add-ins now work across Office 2016 running on Windows, Office Online in your browser, Office 2016 on the Mac (Outlook currently) and Office on the iPad.
Office 2016 on Windows introduces some new extensibility features that will roll out over the other Office clients over time.

Add-in commands

Add-in commands provide ways to initiate specific add-in actions from the ribbon. This lets users access add-ins in a simple, intuitive and unobtrusive way. Because they offer increased functionality in a seamless manner, add-in commands allow developers to create more engaging scenarios and add-ins.
Add-in commands are declared in the add-in manifest in a new node called VersionOverrides. This node ensures backward compatibility because, in an environment that doesn’t support VersionOverrides, existing add-ins will continue to function as they did without add-in commands.
The screenshot below shows add-in commands on the ribbon at the right.
New in Office 2016 for developers 1

There is support for ribbon groups too as shown in this screenshot:

New in Office 2016 for developers 2

Run JavaScript using add-in commands

Add-in commands can also run JavaScript functions without further user input. In Outlook add-ins, you can perform actions such as track, remind me, print or for receiving more in-depth information from a service.

Launch task pane commands

You can use an add-in command button to launch a task pane to get more information from users. For example, the add-in may require changes to settings, or the completion of certain fields.
For details, check out “What UX shapes exist for add-in commands?
New in Office 2016 for developers 3

Theming capabilities for add-ins

You can use the new Theming APIs in your mail and task pane Office Add-ins to integrate your add-in with the Office theme. This widely requested feature allows your add-in to look and feel like the rest of the Office experience—regardless of the user’s preferences. To learn more, see Theme property. The recently announced Office UI Fabrictakes advantage of this new API.

New in Office 2016 for developers 4

Excel and Word Office.js functionality

The new Excel and Word Office.js APIs provide a variety of Excel and Word specific functionality related to the documents being collaborated on. Examples include populating content controls in Word or inserting formatted charts in Excel and are a result of UserVoice feedback from Partners and developers worldwide submitted. We’ve been working on a Snippet Explorer for both Word and Excel to let you browse through code snippets for common scenarios and learn how the new Excel and Word APIs work.
The example below highlights the Diet Tracker code sample that inserts rich charts using the Office.js APIs in Excel:
New in Office 2016 for developers 5

This screenshot highlights a Statement of Work Builder code sample that inserts rich formatted content into a document using Office.js in Word:

New in Office 2016 for developers 6

New in Office 2016 for developers 6

For more information on the new Word and Excel Office.js capabilities, read “Increase the productivity of users with enhanced Office.js APIs in Office 2016.”

My apps now are My add-ins

Office 2016 has been updated to reflect the platform name change from “apps for Office” to “Office Add-ins.” For details about the name change, see “New name for apps for Office and SharePoint: Office and SharePoint Add-ins.

New in Office 2016 for developers 7

Our partners

We continue to acquire more incredible partners in our Store. As mentioned in a previous blog post: Uber, PayPal,Evernote and Boomerang all have released add-ins that take advantage of these new development features.
New in Office 2016 for developers 8
PayPal task pane add-in paying a person directly within Outlook.
New in Office 2016 for developers 9
Boomerang task pane add-in inserting availability into the body of a mail.

New in Office 2016 for developers 10