Sep 28, 2015

Creating reports using OData Feed in Power BI

2 comments  
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
Articles in SharePoint Business Intelligence (BI) series: ðŸ”—
Power BI in SharePoint Online
Creating reports using OData Feed in Power BI
Power View report in SharePoint
Display Power BI reports 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:
  1. https://msdn.microsoft.com/en-us/data/hh237663.aspx 
  2. https://support.office.com/en-us/article/Access-OData-Feeds-from-Power-Query-82BD48B9-6A2F-4F2A-83C9-6868BA1D30E2
  3. http://www.odata.org/   
    Read my article from the following TechNet link and share your valuable comments:

                     Creating reports using OData Feed in Power BI

    Power 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 BI and Power BI Technical Guru - September, 2015.
    Gold Winner!!!!
    Also, this post is highlighted in TechNet Wiki Magazine, 12th edition | Last Articles Spotlight and Guru Awards Edition. :)

    Aug 28, 2015

    Tabbed View Report using SSRS

    No comments  
    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:
    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 with you all that my first TechNet article is awarded for SQL BI and Power BI Technical Guru - August, 2015.
    Gold Winner!!!!
    Ref: http://blogs.technet.com/b/wikininjas/archive/2015/09/19/technet-guru-awards-august-2015.aspx