by Melissa Coates | Nov 30, 2016 | SQL Chick
This is part 2 of a discussion about a new service in Microsoft Azure: Azure Analysis Services. Azure AS is a Platform-as-a-Service (PaaS) offering which is in public preview mode (as of November 2016). Part 1: Why a Semantic Layer Like Azure Analysis Services is...
by Gil Raviv | Nov 29, 2016 | Data Chant
Follow Me Power BI Desktop November Update (2016) is out with amazing new features. In today’s blog post, I would like to focus on a new functionality which simplifies the authoring experience of query functions. This post first appeared...
by Gil Raviv | Nov 23, 2016 | Data Chant
In case you missed this important functionality in Excel 2016, today’s short blog post is written to raise some attention to a wonderful feature. You can write VBA code or PowerShell scripts to automate the creation of queries, change their M expression and copy...
by Melissa Coates | Nov 18, 2016 | SQL Chick
Today I noticed there are a LOT more settings available in the Power BI Admin Portal than the last time I checked. Here are all of the choices currently available: This post first appeared...
by Gil Raviv | Nov 16, 2016 | Data Chant
Following my last post here, Imke Feldmann, author of THE BICCOUNTANT, proposed a refined version for the solution. While my original solution is simpler for users who are reluctant of manipulating Power Query (M) expressions, Imke’s solution is simpler for advanced...