Posts

Showing posts from 2015

Creating reports using OData Feed in Power BI

Image
Today, I published my second Tech Net article about creating reports in Power BI using OData feeds after winning gold winner for TechNet Guru August month :)

To learn about basics of Power BI, click this article: Power BI in SharePoint Online

Scenario:
In this article, let’s get the data from OData (Open Data Protocol) feeds and use the Power BI desktop software to design reports and publish it to Power BI site

To learn more about what OData is and how to integrate, read the following articles:
https://msdn.microsoft.com/en-us/data/hh237663.aspx https://support.office.com/en-us/article/Access-OData-Feeds-from-Power-Query-82BD48B9-6A2F-4F2A-83C9-6868BA1D30E2http://www.odata.org/ Read my article from the following TechNet link and share your valuable comments:
Creating reports using OData Feed in Power BIPower BI Dashboard screenshot reference:
Power BI Dashboard from mobile app reference:



Update 26-Oct-2015
I am happy to share with you all that my second TechNet article is awarded for SQL…

Tabbed View Report using SSRS

Image
Today, I published my first Tech Net article about creating Tabbed View Report using SSRS. SQL Server Reporting Services is a powerful BI tool by Microsoft.
Soon, I will publish articles about SSRS and its integration with SharePoint. Read my article from the following link and share your valuable comments: Tabbed View Report using SSRS Scenario Explained in the article: Suppose take an example employee database which stores their professional summary, salary information, personal information, etc. The end user will search for an Employee by Emp ID as the parameter only one time and the result will be displayed in a tabbed view like professional summary in one tab, salary in another tab and personal information in another tab. Each tab should be clickable and when a Tab1 is clicked, other Tab result should be hidden. In the similar way, show and hide data should work for all the other tabs. Don't forgot to share this post if this helps you!

Update 22-Sep-2015
I am happy to share wit…

Deprecated Features in SharePoint 2016 Preview

SharePoint Foundation 1. SharePoint Foundation 2013 remains available for use 2. Previous releases of SharePoint Server included SharePoint Foundation, a free edition of SharePoint that included most of the core functionality and architecture provided by the commercial editions of SharePoint. SharePoint Foundation is no longer available in the SharePoint Server 2016 release. Standalone Install mode SharePoint Server 2016 IT Preview doesn't support the standalone install option, so it is no longer available in the setup program. Use the MinRole during installation and choose one of the available install options. The Single Server Farm option where everything is installed on the same computer is supported for dev/test/demo purposes. When you use this option, you must install SQL Server yourself and then run the SharePoint Server 2016 farm configuration wizard.. For more information, see "MinRole farm topology" in New and improved features in SharePoint Server 2016 IT Previe…

SharePoint 2016 Preview Arrived

I am excited to share the news with my blog readers that SharePoint 2016 Preview is arrived and it is available for download in the below link:
http://www.microsoft.com/en-us/download/details.aspx?id=48712

SharePoint 2016 Forum Discussions:
https://social.technet.microsoft.com/Forums/en-us/home?forum=SP2016
Customer Feedback Link:
http://sharepoint.uservoice.com/forums/282887-customer-feedback-for-sharepoint-server

Soon will explore on SharePoint 2016 and post you all about the new features and updates :)

Power BI in SharePoint Online

Image
I am very excited after Microsoft released Power BI GA (general availability) at the end of July. It comes with list of impressive new features which is explained in detail in this MSDN article.
I want my blog readers to know what is Power BI and how it can be used with SharePoint Online to leverage the BI capabilities of SharePoint. Let's learn the basics in this article:

Microsoft came with a new tool for BI for the following reasons:
Use the known tool  - ExcelDiscover More  - Power QueryAnalyze More – Power PivotVisualize  - Power View / Power MapCombine with Office 365 – share with any onePower BI sites – collaborate and share the data sets with your teamDive into Q & A – ask a question and get answers visuallyStay Connected – Mobile AppsSchedule data refresh and create security settings easilySo what is Power BI?
Cloud based service works with excel to provide users a complete self-service BI solution Available in SharePoint & Excel 2013 Online (available only in E3 / …

Power Query and Power Map in Excel 2013

Image
As you all know, Microsoft is improving the BI capabilities with a lot of new features with exciting releases in the year 2015. Microsoft has introduced new add-ins called Power Query and Power Map for Excel 2013.
Believe me guys, this is really awesome add-ins which taken the Microsoft's BI capabilities one step ahead of all other BI competitors!
Let's try to create a power map by searching a public data using power query in Excel 2013 in this article.
Before trying a sample, let's understand what is power query and power map for excel 2013 and it's download links:
Power Query:
MicrosoftPowerQueryforExcel (a data analysis tool) is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, combine, refine, access and collaborate.Power Query supports importing data from a wide range of Web sources, including scrapping tables from HTML pages, as well as importing data from Web APIs. Power Query supports XML, JSO…

Get set, update!!!! Windows 10 is here

Image
I am feeling excited to see the Windows 10 upgrade is started!!!

Rock and Roll !!! Will update you all soon about the features and my first experience after the update!

Update running from Windows 8.1 OS.

Create Business Intelligence Center in Office 365

Image
Recently, Microsoft has updated Power BI features in SharePoint online. It has enhanced the Business Intelligence features a lot and I am sure self-service BI is the ultimate goal :) In this article, we will learn how to create Business Intelligence Center in Office 365.

To get  Microsoft Office 365 trail with Business Intelligence Center (this feature is not available in all the versions of the O 365), you need to sign up using the E3 license. This includes the advanced features in it.
Office 365 Enterprise E3 
Once you sign up, navigate to Office 365 admin center -> Admin -> SharePoint -> It will open the SharePoint administration

Click Site Collections -> New -> Private Site Collection -> Give the Title and Web Site Address -> Template Selection -> Enterprise tab -> Business Intelligence Center ->  Enter the site collection Admin and click OK to create it.
You will see the new BI site collection as shown below: Soon, will post about creating dashboards…

Get Windows 10 from Windows 8.1

Image
I know everyone is excited and waiting for the 29th of July, 2015 for Windows 10 upgrade which is FREE  :)

I have Windows 8.1 version in my system.

Points to be noted for getting Windows 10 FREE upgrade from Windows 8.1:

1. You should have a licensed version of Windows OS installed.
2. You should have all the latest updates of Windows installed successfully
3. When you have all the latest updates installed, you will automatically see an Windows 10 icon in the task bar as shown below:
4. When you click on the icon, you see an pop up window showing the steps to get Windows 10 as shown below:
5. When you click on the blue icon on the left top corner, you will see various menus -> click View Confirmation under Getting the upgrade:

Here you can enter your email ID associated with Windows Account to reserve your Windows 10 for free :)
You should see a screen as shown below if your Windows 10 copy is reserved:
According to Microsoft's latest press release, it is going to be LIFETIME …

Could not load type ‘Microsoft.AnalysisServices.SpAddin.ReportGallery.ReportGalleryView’

Image
Recently, I have installed the power pivot in SharePoint 2013 and then configured the power pivot service application in the Central Administration. I tried creating a Pivot Gallery and it is successful. When I opened the pivot gallery library, it is showing the below error:  I am sure some feature is not activated but couldn’t find it. Then, checked the Central Administration -> System Settings -> Manage Farm Solutions -> powerpivotwebapplicationsolution
This solution should be deployed to the web application in which have created the pivot gallery.
Happy learning! Please share this post if it helps you!

SharePoint 2013 / Office 365

I wanted to try some proof of concepts using SharePoint 2013 and been looking for various easy options to get the SP 2013.
Hence I wanted to list the easy ways to get SharePoint 2013 for the readers. Below is the list:

Office 365 Trial :

https://products.office.com/en-us/business/compare-office-365-for-business-plans

On-Premises Deployment:

https://www.microsoft.com/en-us/evalcenter/evaluate-sharepoint-server-2013

Windows Azure:

https://azure.microsoft.com/en-us/pricing/free-trial/?CR_CC=200256621&WT.mc_id=A24158309 

SharePoint Online:

https://products.office.com/en-us/SharePoint/compare-sharepoint-plans?legRedir=true&CorrelationId=08d4bcac-2e4e-4269-9981-1deb00da1ad9

SharePoint Rackspace:

http://sharepoint.rackspace.com/free-sharepoint-2013#chat 

Cloud Share:

http://www.cloudshare.com/cloudshare-template-library

This are the some of the easier ways to get the trial versions for SharePoint 2013. Please share this post if this is helpful. Happy Sharing!

External List in SharePoint Limitations

When I tried to connect the external DB to the SharePoint using external content types, I found lot of issues or limitations for the end users. This is same in external lists as well. I am using SharePoint 2010. No look up: Unfortunately the only thing that you can do a look up on in an external list is on the ID column, anything else and you are out of luck. No Attachments: Attachments options are not available. No RSS Feeds: RSS feeds is also greyed out and it really helps when you need updates from SharePoint list No Workflows: Workflows are very important in SharePoint lists and it plays a vital role in different business requirements. But workflows are disabled in external lists No Ratings: In all the SharePoint lists, you will see an option of Rating Settings under General Settings where the Rating can be enabled but this is disabled
No Inline Editing or Datasheet View:
Inline editing allows you to edit list items in list view itself. Datasheet view is a where you can easily change the dat…

Update on InfoPath and SharePoint forms

As part of the update shared around the Evolution of SharePoint and the next SharePoint Server on-premises release, we are also updating the timelines for removal of InfoPath Forms Services components of SharePoint and SharePoint Online. Specifically, InfoPath Forms Services will be included in the next on-premises release of SharePoint Server 2016, as well as being fully supported in Office 365 until further notice. Customers will be able to confidently migrate to SharePoint Server 2016 knowing that their InfoPath forms will continue to work in their on-premises environments, as well as in Office 365.  The InfoPath 2013 application remains the last version to be released and will work with SharePoint Server 2016. Ref : http://blogs.office.com/2014/01/31/update-on-infopath-and-sharepoint-forms/  This gives answer for many migration questions with regard to InfoPath forms in SharePoint lower versions.