Friday, August 28, 2015

PowerBI is enhanced in the latest update

Not too long ago PowerBI got the GA status. You may want to read up on the following related stuff:

PowerBI and the Cloud

PowerBI on Gartner's Magic Quadrant

Report from SQL Anywhere 16 using Microsoft Power BI

Report from an EXCEL application

Rapid reporting with Microsoft Power BI

Microsoft Intelligent System Services

Power BI Unchained

 A new update to PowerBI was announced recently and this is the latest update as of 8/20/2015.

These following are the advertised improvements:

  • Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file
  • HDInsight Spark connector
  • Azure SQL Data Warehouse connector
  • Support for Custom MDX/DAX queries when importing data from SSAS
  • Navigator dialog improvements: ◦Resizable Navigator dialog
  • Ability to multi-select items in Navigator (CTRL+Click, SHIFT+Click, etc.).
  • Query Editor improvements: ◦Query Group creation/deletion improvements (multi-select, etc.)
  • Ability to Split Query (i.e. refactor common base steps into a new query)
  • Query Icons to reflect type of query in Queries navigator pane
  • Data Modeling improvements: ◦Resizing of columns in Data View
  • Moving Measures from one table to another
  • Live Analysis Services Connections: Ability to change the database from Edit Queries dialog.
You can see there are plenty of things coming together and probably frequent updates keeps needed things in good focus. Since connectors are the next big thing, there are new connectors which should add to productivity.

You download the new PowerBI from the link mentioned earlier.

While using the previous PowerBI with ODATA I had experienced problems creating relationships and the auto-detect relationship feature was not working. Trying to create known relationship also produced the same errors and I believe they were related to something connected to the Analysis, or the model. I will revisit this problem and if you come back later you may find a related post.

Interestingly as soon as the error was generated Microsoft wanted to know about it and a sort of 'ticket' with all relevant information from my application was generated and mailed to Microsoft. I am sure it will be scrutinized.

PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...