Power BI – February 2018

Power BI February 2018 version, released on: 5th of February – 2.55.5010.521 12th of February – 2.55.5010.621 16th of February – 2.55.5010.641 Here’s the complete list of February features: Reporting Multi-select data points across multiple charts Sync slicers across multiple pages of your report Numeric range slicer improvement – whole number snapping (preview) Faster geocoding … Read morePower BI – February 2018

Free Power BI Training and Books

Hi All, Almost every week a friend, colleague, customers or family members (yes, family member…) ask me about Power BI Training. This is the reason I decided to write this post about Free Power BI Training and Books. On-Line Training Microsoft Microsoft provides a good documentation of Power BI, including Power BI Services, Power BI … Read moreFree Power BI Training and Books

Power BI Exam – 70-778 Analyzing and Visualizing Data with Microsoft Power BI

Microsoft released Power BI exam 70-778 (Analyzing and Visualizing Data with Microsoft Power BI) around July 2017 as a beta exam and in January 2018 the exam was removed from beta. This week, I decided to do the exam and it was a great experience as I have been working with Power BI since it … Read morePower BI Exam – 70-778 Analyzing and Visualizing Data with Microsoft Power BI

Power BI – January 2018

Power BI January 2018 version, released on: 8th of January – 2.54.4970.761 18th of January – 2.54.4970.961 Here’s the complete list of January features: Reporting Show and hide pages Control data label background color for Cartesian and maps visuals Increase area used for axis labels in charts Bar/column padding control Show dates as a hierarchy … Read morePower BI – January 2018

Power BI – December 2017

Power BI December 2017 version, released on 11th of December. Here’s the complete list of December features: Reporting Q&A for report creation (preview) Cross-highlighting for bookmarks More bookmark flexibility Field properties pane and field descriptions Scatter visual from x- & y-axis groupings High density sampling for maps based on latitude and longitude Responsive slicers New … Read morePower BI – December 2017

Deployment failure with Azure Analysis Services

Today when I was deploying an Azure Analysis Services in Australia Southeast region, I got the error below. STATUS: Conflict PROVISIONING STATE: Failed TYPE: Microsoft.AnalysisServices/servers System.Fabric.FabricTransientException: The operation failed because the service is currently offline. I tried to deploy AS in another Azure region (WEST US), which was completed successfully. After that, I realized the issue … Read moreDeployment failure with Azure Analysis Services

Exam 70-475 Designing and Implementing Big Data Analytics Solutions

In this post, I would like to share my experience on how to study to Microsoft Exam 70-475 Designing and Implementing Big Data Analytics Solutions. This exam will test your knowledge on Azure HDInsight, Data Lake Analytics, Azure Data Factory, Azure Machine Learning, Azure IoT, Azure Event Hub, Azure Stream Analytics and Azure SQL Database. … Read moreExam 70-475 Designing and Implementing Big Data Analytics Solutions

SQL Server Row-Level Security (RLS)

In this post, I will explain how to setup and use SQL Server Row-Level Security (RLS). RLS is available from SQL Server 2016 and also on Azure SQL database. RLS is used to control access to rows (records) in your database table, restricting employees to ONLY access rows related to their department, region or any … Read moreSQL Server Row-Level Security (RLS)

Azure SQL Database cross-database queries

In Azure SQL Database, you need to use Elastic Queries to run a query that access data from other databases, which is called cross-database queries. You probably have done it in SQL Server on-premises or IaaS, where you access tables from other databases by typing <database name>.<schema name>.<table name>. In this post, I will show … Read moreAzure SQL Database cross-database queries