Microsoft Power BI

Experience what's coming next

What is Power BI?

Power BI is a cloud service that lets you share, collaborate and access your Excel reports anywhere on any device.

Learn moreSee it in action

Do More with Excel

With Excel 2013 Discover, Analyze and Visualize your data like never before.

Learn moreTry Excel with Office 365

What’s New

Leader in Agile BI

Microsoft named a leader in Agile Business Intelligence by Forrester.

See the report

Power BI Newsletter

Sign up for our Power BI newsletter to get updates on everything Power BI.

Sign up

Webinars

Watch on-demand or register for our next live webinar

Learn more

Power BI Blog

  • What's new in the April release of the Analysis Services Connector?

    This is an in-place upgrade: if you already have the Connector installed, you do not have to uninstall it before installing the new version. Also, you do not have to reconfigure the Connector after installing the new version. 

    What's new in the release

    1. Feature enhancements

    2. Better diagnostics and bug fixes

     

    1. Feature Enhancements

    a. Automated checks for prerequisites during installation & configuration of the Connector to ensure Power BI can connect to the Analysis Services Server via the Analysis Services Connector 

    For example, we'll validate whether the Power BI account can connect to the Analysis Services Server with the effective user name mechanism. If you get the error in the image below, it means that your Power BI username does not match your on-premises username. Hence the effective user name mechanism that Power BI relies on to connect to the Analysis Services Server could not work. 

    To fix it, you'll have to ensure you use your work email address with Power BI or your on-premises Active Directory is synchronized with Azure Active Directory. 

    Learn more about the Analysis Services Connector to understand the role the effective user name plays & why the Active Director to Azure Active Directory sync is needed. 

     

    b. Support for network proxy

    You can now use the Analysis Services Connector within network environments which use proxy servers for HTTP connections. In the previous versions, if your organization's network was using a proxy, under some situations, the Connector would fail to start up. This experience has now been improved.

    c. Notification when a new version of the Connector is available

    You will see a notification in the Analysis Services Connector when a new version is available for download. Click on the link to download & install the new version. You do not have to uninstall the previous version or reconfigure the Connector after installing the new one. 

     

    d. Support for all languages Power BI is available in.  

    Along with Power BI, the Analysis Services Connector is also available in all languages supported by Power BI. For more information check world wide availability of Power BI 

    2. Diagnostics and bug fixes

    a. Improved error messages in the Connector and in the Power BI service to help you diagnose and fix issues. 

    For example: When the password of a Windows user expires, you'll see the following message in the Connector. You'll also see a similar error message in the Power BI service when you try to connect to the dataset or open a report. 

    To fix it, in the Connector click Edit and update the password. 

     

    In addition, we have also taken care of several bugs reported. For example this one.

    We have receive lots of feedback for the Connector and we'll continue to improve it. Stay tuned as updates roll out more frequently!

    #Power BI#Business Intelligence#data visualization#hybrid#SQL server#Analysis Services#Connector#SSAS#On-Prem

    Sat, 18 Apr 2015 02:30:00 GMT byPower BI Team0 Comment

    Read post
  • Visualize and Explore your Google Analytics data with Power BI

    When you own a website, analyzing and tracking your site’s traffic is critical. Knowing where your viewers are coming from, what days they come the most frequently, and how long they’re staying are just some of insights that you can use to help improve your site and inform your decision making.

    If you are using Google Analytics for web site usage tracking and digital measurement, we have great news for you.

    Now you can use Power BI to monitor, explore and visualize your Google Analytics data. With an out of box content pack, you can connect and gain insights into your data immediately. You can also connect directly through the Power BI Designer, allowing you to build your own reports and even create mashups with other sources that are important to you, ensuring all your data is in one place.

    Out of Box Content

    Connecting to Google Analytics in Power BI is easy; immediately after you connect you’ll gain insights around the usage of your site in the last 6 months. Using the Google Analytics API, this content pack provides a dashboard, a report and a dataset to allow to you monitor and explore your data.

    Miguel Escobar from Powered Solutions is an avid Power BI customer and was very excited to hear we had support for Google Analytics. Connecting through his account, his out of box dashboard looks like the one below.

     

    When connecting you can choose the account, property and view to connect to. This information can be found in your Google Analytics account, under the Home tab.

     

    After connecting, your data will start to load into Power BI and you’ll be notified when your dashboard is ready. Selecting one of the tiles will drill into the 5 page report built on top of the data set.

     

    You can also use Q&A to explore your data, such as asking questions about the website traffic - “total hits” or “total page views by date in the last 30 days”. You can ask questions about specific data points as well, such as “total sessions by browser where device is a tablet”. Every result can be pinned back to your dashboard to customize it however you want.

     

    You can also pin data from other datasets to your dashboard. For example, if you’re tracking your mail campaigns using Marketo you can see the results of your latest campaign, right next to your site traffic.

     

    Power BI Designer

    The Power BI Designer also allows you to connect directly to Google Analytics to build your own set of reports.

    To get started, download the latest version of the Power BI Designer. In the Get Data dialog, under the Other sources or using the search box in the top left, you’ll find Google Analytics:

     

    This connector leverages the Google Analytics API, allowing you to access all the data provided when enabling Google Analytics for your site. After selecting it from the list of sources, you’ll be prompted for your credentials and to allow Power BI to access your account.

    Once you connect, you’ll see a list of the accounts you have access to. Drill through the account, properties and views to see a selection of values, categorized in display folders. For example, try selecting Session > Sessions and Geo Network > Country to see the breakdown of session for the view by country.

     

    As you select different values, we’ll send a query back to the source to get the result. The output will be a single flat table will all the values you selected. Google Analytics has a limit on the number of items you can select together, so select the initial set and build as needed.

    Additional operations, such as filtering on the dates you selected, will also be sent in a query to Google Analytics. After loading the tables or switching to the Report view, you’ll be able to visualize and explore your data.

    Here’s a view that Miguel built himself, showing page views over time as well as by language and page title.

     

    What will you built with the Google Analytics connector?

    We’re always interested in hearing your feedback – please leverage http://support.powerbi.com to let the team know how your experience was and if there’s anything we can do better. We look forward to your feedback!

    #Power BI#Business Intelligence#data visualization#dashboard#Connector#Google Analytics#Digital Marketing#Traffic#Website Metrics#Website Tracking

    Wed, 15 Apr 2015 15:00:00 GMT byPower BI Team8 Comments

    Read post
  • Monitor and track your SendGrid email delivery stats using Power BI

    SendGrid is an incredibly powerful “Email Infrastructure in the Cloud” platform. If you use SendGrid as a means for reaching your customers via email, then it is very easy to use Power BI as a means of monitoring and analyzing your email deliverability statistics.

    Power BI provides an instant, out of the box dashboard over your SendGrid data. Using Power BI, you can analyze your SendGrid data in minutes. This blog post shows you how to connect to your SendGrid data and explore your email deliverability in depth.

    Monitoring your SendGrid data

    The dashboard you can create over your SendGrid account looks like the one below.  The dashboard is fully customizable so you can tailor it to your needs.  You can also combine data from this dashboard with data from other sources to create a single unified view of all the data you need to get your job done.

     

    This dashboard lets you track overall trends for your Requests, Email Opens, Email Clicks, Spam Reports, etc. You get a quick glance at your overall Delivery Rate (%) as well as stats such as Spam Report Rate (%) and Unsubscribe Rate (%).

    Also included, you will find Browser and Device based stats for Click/Open rates. You will also find Click/Open rates by Geography.

    One of our favorite features in the SendGrid dashboard is the ability to view stats by category—more  on this in a bit when we talk about categories.

    Exploring your SendGrid data in depth

    While the dashboard view contains most of the key statistics you would want to glance at, there are a whole lot of insights that sit right beneath the dashboard that are accessible for you via interactive exploration. Clicking on a tile on the dashboard makes it possible to look at a drill down view of the data.

    Here’s an example of a more detailed summary view that shows the key metrics and trends for the last 90 days:

     

    And as another example, shown below is a view of the geographical stats that you can explore:

     

    When you are in the exploration view, you can switch between the pages of your report. Clicking the page number shown at the bottom of the report will open the page navigator that will help you switch to a different report page.

     

    As mentioned previously, the Power BI content pack lets you view your email statistics by custom categories that you may have used to tag your emails. This makes it really easy for you to view email delivery breakdowns by the different types of activities you may use SendGrid for. For example, you may tag your user alert emails with the category “User Alert” and you may send your password reset emails with the category “Forgot Password.”

    Here’s a view of email statistics by category (accessible from Page 6 of the reports view):

     

    Connecting to your SendGrid account from PowerBI

    Connecting to your SendGrid account is easy. All you need is your SendGrid username and password. You just need to make sure that your SendGrid account is configured for API access; Power BI simply uses the SendGrid API to import statistics into your Power BI account.

    The following steps assume that you already have a Power BI account. If not, create one by going to http://www.powerbi.com.   

    Once you are logged into Power BI, click on the Get Data link in the top left corner.

     

    This will take you to the gallery of content packs that are available for you to consume. Each of these content packs will help you import your data into Power BI, from the various sources listed.

    Clicking on SendGrid will show you details of the SendGrid content pack.

     

    When you click on Connect, you will be prompted to enter you credentials.

     

    Once you enter your credentials, the data import process will begin. It could take a couple of minutes for your data to be imported into Power BI – but that’s all there is to getting instant insights out of your SendGrid account!

    If you run into issues or need help getting going, please do not hesitate to reach out to us. You can contact support either by clicking the “?” when you’re signed in to your Power BI account or from the “Contact Support” link on our support site. 

    http://support.powerbi.com

     
    #Power BI#Business Intelligence#data visualization#dashboard#Sengrid#Connector#Marketing#Email Campaign#email deliverability#Email Infrastructure

    Thu, 02 Apr 2015 15:00:00 GMT byPower BI Team2 Comments

    Read post