20

Sep

Backup Compression for TDE-enabled Databases: Important fixes in SQL 2016 SP1 CU4 and SQL 2016 RTM CU7

Source: https://blogs.msdn.microsoft.com/sql_server_team/backup-compression-for-tde-enabled-databases-important-fixes-in-sql-2016-sp1-cu4-and-sql-2016-rtm-cu7/   Backup Compression and Transparent Data Encryption (TDE) have been two immensely valuable and popular features for customers in SQL Server. In SQL Server 2016, backup compression was enabled for TDE databases where if you backup a TDE READ MORE

20

Sep

Invoking Azure ML Web Services from Excel, Using Power Query
Invoking Azure ML Web Services from Excel, Using Power Query

This post is authored by Amita Gajewar, Senior Data Scientist at Microsoft.

Problem Statement

Microsoft Azure Machine Learning Studio lets data scientists build machine learning models for a variety of problems that require predictive analytics capabilities. The Studio publishes these models as web services which can then be invoked via REST APIs, i.e. to send it data and get back predictions.

For business analysts who spend a lot of time manipulating and visualizing data in spreadsheets, it would very useful to be able to invoke an Azure ML web service from right within that environment, by passing in appropriate parameters and have the results populated back into the spreadsheet. To go one step further, they would be able to process and format the returned results, before displaying them in tables or charts.

In this post, we explain how to accomplish this using Power Query and macros within Excel.

Power Query provides a method to query, combine and refine data across a wide variety of sources including databases, the web, Hadoop and more. For illustration purposes, I create a Power Query to invoke an Azure ML web service that forecasts various financial metrics (e.g., revenue, EPS, etc.) for the 30 Dow

19

Sep

Managing Pipeline & Recurring Jobs in Azure Data Lake Analytics Made Easy

Source: https://blogs.msdn.microsoft.com/azuredatalake/2017/09/19/managing-pipeline-recurring-jobs-in-azure-data-lake-analytics-made-easy/   Azure Data Lake Analytics (ADLA) is a big data job service that enables you to develop and run data transformation and processing jobs over petabytes of data. With no clusters or servers to provision or manage, you READ MORE

19

Sep

Five ways edge computing will transform business
Five ways edge computing will transform business

Source: https://blogs.microsoft.com/iot/2017/09/19/five-ways-edge-computing-will-transform-business/     The Internet of Things (IoT) has been called “the mother of all infrastructures”—and it’s a revolution that has arrived. IoT is no longer just a niche solution for a handful of businesses but a core technology READ MORE

18

Sep

Power BI Developer community September update
Power BI Developer community September update

Source: https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-september-update/           This blog post covers the latest updates for Power BI Developers community. This includes Power BI Embedded updates, changes to custom visuals and R, and improvements to Row-Level Security.

17

Sep

Getting Started with Azure Analysis Services Webinar Sept 21
Getting Started with Azure Analysis Services Webinar Sept 21

Source: https://powerbi.microsoft.com/en-us/blog/getting-started-with-azure-analysis-services-webinar-sept-21/           The Azure Analysis Services team would like to help you get started with this exciting new offering that makes scaling Business Intelligence solutions easier than ever.

15

Sep

On-premises data gateway September update
On-premises data gateway September update

Source: https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-september-update/           We’re very glad to announce that the September update for the On-premises data gateway is now available for download. This update includes the following enhancements: Personal Mode support for…

15

Sep

Don’t miss the Timeline Storyteller custom visual contest!
Don’t miss the Timeline Storyteller custom visual contest!

Source: https://powerbi.microsoft.com/en-us/blog/don-t-miss-the-timeline-storyteller-custom-visual-contest/           Don’t forget: there’s only a few days left to enter the Timeline Storyteller custom visual contest! You could win a Power BI Super Swag Prize Pack. To enter, publish a report in the READ MORE

15

Sep

Power BI in action: using custom connectors
Power BI in action: using custom connectors

Source: https://powerbi.microsoft.com/en-us/blog/power-bi-user-group-custom-connector/           Power BI User groups (PUG) are groups for great people like you (yes, you reading this!) to get together with other awesome people to talk, discuss, and share experiences, questions, and more around READ MORE

14

Sep

Congratulations to the winners of the What If contest!
Congratulations to the winners of the What If contest!

Source: https://powerbi.microsoft.com/en-us/blog/congratulations-to-the-winners-of-the-what-if-contest/           A few weeks ago we launched a “What If” contest to promote the release of our new What If feature in Power BI Desktop. Many of you were anticipating this feature for a READ MORE