Author : All posts by ilikesql

13

Aug

Announcing the deprecation of custom visual’s API version 1.1 and older

https://powerbi.microsoft.com/en-us/blog/announcement-custom-visual-api-deprecation/Source: https://powerbi.microsoft.com/en-us/blog/announcement-custom-visual-api-deprecation/           As of September 1st only API 1.2 and above will be supported.

Share

13

Aug

Working with PowerShell in Power BI
Working with PowerShell in Power BI

https://powerbi.microsoft.com/en-us/blog/working-with-powershell-in-power-bi/Source: https://powerbi.microsoft.com/en-us/blog/working-with-powershell-in-power-bi/           If you are following the Power BI blog on a regular basis, you probably have noticed the Power BI APIs and cmdlets announcement for administrators, which introduced a set of APIs and cmdlets READ MORE

Share

13

Aug

Azure #CosmosDB reference solution: Visualizing real-time data analysis with change feed

This blog post was co-authored by Devki Trivedi, Serena Davis, and Pascal Habineza.

The Cosmos DB Explorer Interns are excited to release a reference solution that utilizes the Azure Cosmos DB Change Feed feature (+ Azure Functions, Azure Event Hubs, Azure Stream Analytics, Power BI). This solution features a hands-on lab that guides users through the entire pipeline: from uploading data onto Cosmos DB to implementing a Change Feed trigger to visualizing that data in a meaningful way on Power BI.

With this reference solution, businesses can:

Track sales and site activity in real time  Manipulate data to see only the metrics useful to them Choose specific time windows for data to be processed

The Cosmos DB Change Feed provides an automatic mechanism for getting a continuous and incremental feed of modified or inserted records from Cosmos DB. A few of its most popular use cases include:

Triggering microservices and functions within an event-driven architecture Replicating data to secondary data stores Real-time data processing

This reference solution focuses on real-time data processing, specifically to fit the needs of e-commerce companies. For example, while an e-commerce company may currently track the most popular products purchased, it may want to improve

Share

13

Aug

How to enhance HDInsight security with service endpoints
How to enhance HDInsight security with service endpoints

HDInsight enterprise customers work with some of the most sensitive data in the world. They want to be able to lock down access to this data at the networking layer as well. However, while service endpoints have been available in Azure data sources, HDInsight customers couldn’t leverage this additional layer of security for their big data pipelines due to the lack of interoperability between HDInsight and other data stores. As we have recently announced, HDInsight is now excited to support service endpoints for Azure Blob Storage, Azure SQL databases and Azure Cosmos DB.

With this enhanced level of security at the networking layer, customers can now lock down their big data storage accounts to their specified Virtual Networks (VNETs) and still use HDInsight clusters seamlessly to access and process that data.

In the rest of this post we will explore how to enable service endpoints and point out important HDInsight configurations for Azure Blob Storage, Azure SQL DB, and Azure CosmosDB.

Azure Blob Storage

When using Azure Blob Storage with HDInsight, you can configure selected VNETs on a blob storage firewall settings. This will ensure that only traffic from those subnets can access this storage account.

It is important to

Share

10

Aug

Connect with the Microsoft Power BI Team at Power Summit Phoenix October 15-18 in Phoenix, AZ

https://powerbi.microsoft.com/en-us/blog/connect-with-the-microsoft-power-bi-team-at-power-summit-phoenix-october-15-18-in-phoenix-az/Source: https://powerbi.microsoft.com/en-us/blog/connect-with-the-microsoft-power-bi-team-at-power-summit-phoenix-october-15-18-in-phoenix-az/           Bringing all Power Platform community together at one special event in Phoenix Oct 15th for collaboration, networking and hands-on learning opportunities

Share

10

Aug

Enhance security and simplify network integration with Extension Host on Azure Stack

We are excited to share a new capability we are bringing to Azure Stack to further enhance the security posture and simplify network integration for our customers. Today, each Azure Service on Azure Stack adds functionality to the portal for its portal experience via a module called, a portal extension. Each of these portal extensions uses a separate network port. As the number of Azure services increases, so do the number of ports that must be opened on a firewall that supports Azure Stack.

Our customers told us we need to improve this this posture, and we’ve listened. We’re bringing the Extension Host solution to Azure Stack so only one port (443) is required to be opened. This solution is already available on Azure, allowing all requests to be funneled through one port, reducing the ports that need to be opened on the firewall, and allowing customers to communicate with these end points via proxy servers.

In its first release, the User and Admin portal default extensions have moved to this model, thereby reducing the number of ports from 27 to one. Over time, additional services such as the SQL and MySQL providers will also be changed to use the

Share

10

Aug

Enhance security and simplify network integration with Extension Host on Azure Stack

We are excited to share a new capability we are bringing to Azure Stack to further enhance the security posture and simplify network integration for our customers. Today, each Azure Service on Azure Stack adds functionality to the portal for its portal experience via a module called, a portal extension. Each of these portal extensions uses a separate network port. As the number of Azure services increases, so do the number of ports that must be opened on a firewall that supports Azure Stack.

Our customers told us we need to improve this this posture, and we’ve listened. We’re bringing the Extension Host solution to Azure Stack so only one port (443) is required to be opened. This solution is already available on Azure, allowing all requests to be funneled through one port, reducing the ports that need to be opened on the firewall, and allowing customers to communicate with these end points via proxy servers.

In its first release, the User and Admin portal default extensions have moved to this model, thereby reducing the number of ports from 27 to one. Over time, additional services such as the SQL and MySQL providers will also be changed to use the

Share

10

Aug

Announcing the Power BI Performance Management Solution Template for Azure Application Insights

https://powerbi.microsoft.com/en-us/blog/announcing-the-power-bi-performance-management-solution-template-for-azure-application-insights/Source: https://powerbi.microsoft.com/en-us/blog/announcing-the-power-bi-performance-management-solution-template-for-azure-application-insights/           Today we are excited to announce the release of the Power BI Performance Management solution template for Azure Application Insights. This release brings comprehensive telemetry data into the growing suite of Power BI READ MORE

Share

09

Aug

8/10/18 Webinar: Get actionable insights using real-world visualizations in your Power BI dashboard

https://powerbi.microsoft.com/en-us/blog/8-10-18-webinar-get-actionable-insights-using-real-world-visualizations-in-your-power-bi-dashboard/Source: https://powerbi.microsoft.com/en-us/blog/8-10-18-webinar-get-actionable-insights-using-real-world-visualizations-in-your-power-bi-dashboard/           Walk through using real-world visualizations in your Power BI dashboard. Microsoft Visio offers the perfect canvas for visually contextualizing data and depicting process flows. Using the new Visio visual for Power BI, you READ MORE

Share

09

Aug

Cloud data and AI services training roundup August 2018
Cloud data and AI services training roundup August 2018

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post.

SQL Server

Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux, and Docker containers.

Prepare for Windows Server 2008 and SQL Server 2008 End of Support
Support for SQL Server 2008/ 2008 R2 and Windows Server 2008 will end in July 2019 and January 2020, respectively, which means youll no longer receive security patches for these versions. When you join this session, youll learn how to migrate your applications and data, avoid business disruptions, and adopt the most current security technologies. You will also receive guidance for your migration and find resources to help you move quickly. Azure Database services for PostgreSQL and MySQL

Azure Database Services for PostgreSQL and MySQL provide fully managed, enterprise-ready community PostgreSQL/MySQL database as a service. These community editions help you easily lift and shift to the cloud, using languages and frameworks of your choice. On top of that, you get built-in high availability and capability to scale in seconds, helping you easily adjust

Share