Power BI October, 19 updates


Diwali and Halloween are two great festivals and knocking our door. This October month, Microsoft lances bunch of new features and some great updates on Power BI. Let’s review them in real quick way.

Under Reporting section, they introduce new Automatic page refresh for DirectQuery (preview). This is really great! In Page refresh card, you can just put 1 and every seconds whatever updates made will reflect on your report. Awesome!

Under Analytics section, they introduce new Q&A visual. Bringing natural language generation even more to the forefront of reporting in Power BI with this new Q&A visual. Just drag this visual to your report and play with keyword. It understands your query, it will suggest you the best possible result, it will point out which might be your spelling mistakes and recommend correct key word, allow me to save a keyword with meaningful value. Like a supercomputer running and standing for my key press only!!! Very useful for business users.

Now, Q&A supports SQL Server Analysis Services and Azure Analysis services. Allow to connect your data without first import the data. Super!

Below are few wonderful Visualization updates.

  •        Power Apps visual is now included by default
  •        xViz suite is a set of custom visuals that aim to meet your end-to-end BI needs

·         Hierarchical Variance Table - lets you compare to measures within a hierarchical table layout and see the variance, % variance, and how that contributes to the whole. Having number formatting, semantics formatting, row headers.
·         Linear Gauge - allows you to compare a value to a target value. In the conditional formatting card of the formatting pane, you can set the band thresholds and colors. Other formatting options include: Setting minimum and maximum values + Axis formatting + Data label formatting
·         Tag Cloud - allows you to get instant insights of the more prevalent terms in your data. key features and options include: Split phrases into individual words + Remove special characters + Exclude words + Format the word size, color, angles, and number of orientations

Data connectivity updates
  •    Sagra Emigo connector generally available
  •   Azure Cost Management

§  Supports OAuth 2.0 for authentication
§  Supports both Microsoft Customer Agreement and Enterprise Agreements (EA)
§  Includes enhancements to RI recommendations and RI usage data and the addition of amortized cost
§  Performance improvements
·         
  •     New Workplace Analytics connector - Microsoft Workplace Analytics uses data from everyday work in Office 365 to identify collaboration patterns that impact productivity, workforce effectiveness, and employee engagement.


Data Preparation updates
·         Query Diagnostics is a powerful new feature that will allow you to determine what the Mashup Engine is doing during authoring time.

·         Data profiling enhancements
§  Text: By Text Length (number of characters).
§  Number: By Sign (positive/negative) and Parity (even/odd).
§  Date/DateTime: By Year, Month, Day, Week of Year, Day of Week, AM/PM Time and Hour within a day.
§  And more for other data types (Logical True/False), etc.

Finally, updates on Template Apps: Project Web App -  It can be connected to your own Project Web App data using your own credentials. This template app is comprised of 13 visually rich report pages to support the PWA management needs. 

Here the MS link where more detailed you can observer. Now, let’s get back to your Power Dashboard and enjoy Power BI!

Comments

Post a Comment

Popular posts from this blog

How to fix Azure DevOps error MSB4126

Image
Setting up build and release pipeline always tedious and we face many build related issues. Here is one common error I face couple of times while setting app Web or windows apps in Azure DevOps After placing the code in repos, and creating the build pipeline and run it, you can face the following error ##[error]D:\a\8\s\<your solution file>.sln.metaproj(0,0): Error MSB4126: The specified solution configuration "release|$(BuildPlatform)" is invalid. Please specify a valid solution configuration using the Configuration and Platform properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those properties blank to use the default solution configuration. To understand what is target platform defined in your project you need to visit or open the solution(.sln) file and review the following sections. In my case, this has been defined as x86 as target platform.                   GlobalSecti
Read more

SharePoint Admin Center

Image
 SharePoint Admin Center allows you to view your organization's SharePoint site including communication sites, channel sites, and sites that belong to Microsoft 365 group. This is same like Site Admin in earlier days of SharePoint versions. You can search organizational site, sort them or filter sites the way you want. Easy way to find and apply/change site settings. Under Policies, click on Sharing - This will allow you to create rules/ set control sharing at the organization level in SharePoint and OneDrive Here, in this page, you can apply settings to restrict how users are allowed to access content in SharePoint and OneDrive. Term store, the word getting populated from SharePoint 2010. You can feed metadata of metadata information of your organization level, program level, project level in Term store. helps your organization's knowledge better.  AI soon will play a vital role here and using AI, you can acyually find collect and process and finally yoour organization's d
Read more

How to create Custom Visuals in Power BI – Initial few Steps

Image
This post will help you to know the steps to create custom visuals in PowerBI. Microsoft defined them as well at https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools . First things first, and you need to download and install NodeJS , in case if you do not have npm setup in your machine.  Second step is to run couple of npm commands to install Power BI Visual Tools and create & publish the cert. Finally, create your own package and upload with the help of npm. 1.       npm install -g powerbi-visuals-tools 2.       pbiviz --create-cert pbiviz --install-cert 3.       pbiviz new My Visual name – This will create the file under the name of your visual file. 4.      pbiviz start – You need to go to the folder where your custom visual  resides, and run this command. You can change a few things in your pbiviz.json file, like author, display name, icon, style etc. Finally, package your
Read more