New Features in Power BI From June 2017 Release

image

Figure 1 – Explanation of Power BI from https://powerbi.microsoft.com

On June 12, Amanda Cofsky, Program Manager for Power BI, provided an overview of the new reporting features available as of June.  The link to download Power BI is…. http://powerbi.microsoft.com/desktop?WT.mc_id=Blog_Desktop_Update.

Here’s the complete list of June updates from Cofsky’s blog posting.

Reporting
  • Data bars for new table & matrix (preview)
  • Markers on line, area, & combo charts
  • Accessible reports
    • Consume Power BI reports with keyboard navigation and screen reader support
    • Create accessible reports
  • Visuals font family setting
  • Horizontal Image Slicer
  • Combo chart formatting updates
    • Force zeros to align between the two axes
    • Shade area of the line
  • Bing maps improvements
    • Map themes
    • Improved geo hierarchy experience
  • High density line sampling
Data connectivity
  • Custom Data Connectors support
  • Power BI service Live Connect to On Premises and Push streaming datasets
  • Impala connector is now generally available
  • Amazon Redshift connector is now generally available
  • SAP BW connector – DirectQuery support (beta)
  • IBM Netezza connector (beta)
Query editing
  • “Add Column from Examples” enhancements

You can watch a video of the new features by clicking on https://youtu.be/YlNVE5dgcSI (Power BI Desktop Update – June 2017).  Remember that YouTube links can change from time to time so this link may change over time.


Creating Reports for Power BI Phone Apps

image

Figure 1 – Visual of Sales Dashboard created in Power BI – from Maggie Sparkman’s article “Create reports optimized for the Power BI phone apps”

Maggie Sparkman published a great article on creating desktop reports in Power BI that will translate to the mobile apps on the phones.

Her article appears at https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-create-phone-report/?mobileclient=ios.

In her article, she provides clear, step-by-step instructions on creating the visual.  The article is well worth the read if you are into Power BI.

You Can Use Power BI To Analyze the Top Movies from IMDb And Other Lessons

image

Graphic from https://www.youtube.com/watch?v=ByIUx-HmQbw&list=PL1N57mwBHtN2q1WbU5O29rrn_A0lkVv9p&index=3

 

I think learning should be fun! And, for me, Microsoft made a lesson on learning how to do queries in Microsoft Power BI a lot of fun by using the query on the IMDB database.  I love movies and I use the IMDb database often so I enjoyed the way the lesson categorizes movies.

Want to learn how to start using the Power BI tool?  Well, you can either start by going to the Learn page at the Power BI website at https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-0-0-what-is-power-bi/

Or, you you can go directly to the Power BI Desktop videos, and watch the short movies that also appear on YouTube.  The IMDb example is at https://www.youtube.com/watch?v=ByIUx-HmQbw.

For folks that work with Dynamics GP 2016, these short learning sequences are a great way to discover the ease of creating Power BI reports from a data source.

Enjoy!

Microsoft Power BI Updates in July 2016

 

image

Graphic from https://powerbi.microsoft.com

 

Microsoft announced the following updates for Power BI for July.  The announcement comes from Filip Karadzic,  Senior Program Manager, from the blog announcements page at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary/.

REPORT VIEW:
  • Predefined table styles
  • ShapeMap can use custom maps
DATA CONNECTIVITY:
  • New Data Connectors:
    • Amazon Redshift (Import + DirectQuery) (Preview)
    • Impala (Import) (Preview)
  • Improvements to existing data connectors:
    • Support for specifying a Command Timeout via the UX
    • CSV/Text – Support for Fixed-Width delimited files
    • SAP BW connector improvements:
QUERY EDITING IMPROVEMENTS:
  • Ability to use R scripts in Query Editor
  • Query Parameters – List Query output as “allowed values” for a parameter
  • Ability to overwrite existing user-defined functions

What is Microsoft’s Power BI and How Does It Work?

image

Graphics from https://powerbi.microsoft.com/en-us/

 

What is Microsoft Power BI

“What is Power BI?”   Microsoft defines it as

“Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.

Where Can I Get More Information on Microsoft Power BI?

Microsoft has created a web site for Power BI at https://powerbi.microsoft.com/.  You can find out everything you need to know about the product at this site.

You can also stay updated with all the new features by checking the Microsoft Power BI Blog at https://powerbi.microsoft.com/en-us/blog/.

 

Why Do I Need To Know About Power BI?

Power BI integration to Dynamics GP is a new feature in Dynamics GP 2016.  The big question that all GP users have is about the benefit of Power BI.  The benefit is that users can now connect data to the HOME page, and produce reports and dashboards similar to the way reports and dashboards can be built in SSRS reports.

 

Prerequisites for GP Users To Use Power BI

– You have access to Power BI and at least one report is available.

– You are able to log in to the Power BI site and view a report.

– You are creating your own Power BI reports\charts.

– You are using the GP 2016 desktop client.