Power BI July 2018 Update

                                                                             July update
Data modeling

The most exciting feature of July release is Composite models. This feature lets you seamlessly extend your DirectQuery models with other DirectQuery sources or even imported data. earlier it wasn’t possible to connect many DirectQuery to the same report or with import data.

With this release, that barrier has been removed and single report can combine with one or more DirectQuery source /import data set.

Find out more

Many to many relationship

this is one of the most awaited feature and with this  you can join tables using a cardinality of Many to Many, and create data models that contain multiple data sources easier and more intuitively. The many-to-many relationship feature is part of the larger composite models

Find more here

Analytics (Distribution factor insights)

How you find out new type of insight with your existing data ,now you can find through it Insights feature, which finds different filters that create significant different distributions compared with the original graph. You’ll notice in the insights, we use the stepped line to represent the original chart and the bars of the combo chart to represent the new distribution

More here

Visualization and formatting

More on the visualization and formatting here

This ebook from Mahesh Kshirsagar of the Azure Customer Advisory Team (AzureCAT) will help demystify Kubernetes and show you a real-life scenario in which a basic tiered application is deployed using pods and controllers. You’ll be walked through steps to deploy a simple application with a web front end running ASP.NET Core 1.0 and a back end with a SQL Server container running on Linux

https://azure.microsoft.com/mediahandler/files/resourcefiles/243b3587-a5cd-4937-b52a-dc5bdc8a78e7/Kubernetes-objects-on-Azure.pdf

 

 

Azure SQL Data Sync

Do you need to sync data between azure SQL databases ? or on-prem SQL to Azure SQL ? with unidirectionally or bidirectionally ?
Here is the tool for it “Azure SQL Data Sync” , which is now in GA and ready to deploy to production.

This has many built in features and functionalities to cater enterprise data sync requirements.

The Data Sync uses a hub and spoke topology to synchronize data and can be configured below sync options

Sync Schema
Sync  Direction
Sync interval
Conflict resolution policy

Check out the Azure SQL Data Sync documentation to get started, and get more details from the following content:

Power BI with Visio visual intigrations

This article explain how easily can integrate your viso diagram with PowerBI , even with complex drawing like floor visualization, map or simple workflow diagram can be integrated , also it would be interact with other visuals like slicers,charts,matrix etc.. and user can slicing and dicing

https://support.office.com/en-us/article/add-visio-visualizations-to-power-bi-reports-4f09be62-f436-45c2-93b0-4a0f66b1f5a7

Azure SQL Database Managed Instance ( public preview)

Managed Instance offers full engine compatibility with existing SQL Server deployments including capabilities like

SQLAgent, DBMail, and Change Data Capture, to name a few, and built-on the highly productive SQL Database service

It is designed to enable database lift-and-shift to a fully-managed service, without re-designing the application.  SQL Database Managed Instance provides the broadest SQL Server engine compatibility and native virtual network (VNET) support so you can migrate your SQL Server databases to SQL Database without changing your apps

https://azure.microsoft.com/en-us/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/