Blog

  • Configuring Power BI Report Server May Preview – Part 2

    May 20, 2017

    The May 2017 Preview of Power BI Report Server can be downloaded here. This post explains with guided video examples, how to configure Power BI Report Server May 2017 Preview edition.  This means the configuration part after installing.  If you missed the first part of this series, see the install process here.  To configure Power BI […]

    Read More
  • Create

    10 – TSQL Create Table Statement

    October 11, 2016

    Hi! Today I learned about the Create Table statement, it allows you to create and define tables, as what I studied on the last episode, it is a DDL statement (Data Definition Language). CREATE TABLE The syntax for this statement in SQL Server (TSQL) id: CREATE TABLE table_name ( column1 datatype [NULL […]

    Read More
  • Concepts

    9 – Learning DDL and DML concepts

    September 30, 2016

    Hello there! Learning about DDL and DML concepts is a fundamental foundation for becoming a Data Wrangling and Data Warehousing extraordinaire.  SQL statements are divided into two major categories: Data Definition Language (DDL) and Data Manipulation Language (DML).  In Short: DDL describes a bunch of commands that CREATE Data Structures, like […]

    Read More
  • Let the Good Times Flow in SharePoint Online

    September 28, 2016

    Flow has been available for some time now as a beta program wthin Office365 offering Cloud orchestrated business workflows.   What does this actually mean to a business user? These workflows offer businesses the opportunity to automate, improve operational efficiency, reduce room for error and encourage repeatable experience by automating […]

    Read More
  • T-SQL syntax not acceptable in Azure SQL Data Warehouse

    September 26, 2016

    In your code Migration from SQL Server to Azure SQL DW, you will have to review some T-SQL syntax that are not acceptable in Azure SQL Data Warehouse. Here are the list of commands that will not work in your Azure SQL Data warehouse: ANSI joins on updates ANSI joins on deletes merge statement cross-database […]

    Read More

Power Bi Blog

  • Installing Power BI Report Server May Preview – Part 1

    May 20, 2017

    The May 2017 Preview of Power BI Report Server can be downloaded here. This reference explains with guided video examples, how to install Power BI Report Server May 2017 Preview edition.  This means installing : Power BI Report Server May 2017 Preview, and Power BI Report Server Desktop edition (this edition can […]

    Read More
  • Power BI in SharePoint Looking Good

    November 1, 2016

    This week, the Reporting Services (SSRS) Technical Preview gets released for download.   Not only does this allow you to embed Power BI Reports inside a Reporting Services Native Mode Report Server, but you can embed them inside SharePoint 2016 web part pages too.  And this goes for Reporting Services […]

    Read More
  • Power BI Goes Gangsta with On-Premise Preview

    October 30, 2016

    A Technical Preview of Power BI in SQL Server Reporting Services is now available in the Azure Datacentre.  Following, a release will be available to download and use.  The Update allows Power BI Reports to be viewed inside Reporting Services Native Mode Report Manager.   If you can’t wait a […]

    Read More
  • Bathurst 1000 – It’s Go for Girls and Nissans

    October 10, 2016

    The Bathurst 1000 is a 1,000 kilometre touring car race held every year on the Mount Panorama Circuit, in Bathurst New South Wales, Australia, Oi, Oi, Oi.  During the off season, the circuit, is actually open to the public, driven daily by locals and tourists alike.  It is currently run as […]

    Read More
  • Why Power BI Needs to Run on Android Tablets

    September 27, 2016

    Broken Hill, Australia… was the backbone of the country during two world wars producing ingredients for materials, employment, memories and lifetimes for many…  Now a stark but beautiful place to visit, the best steak in the country, and home of Priscilla Queen of the Desert… and NOT where you want your […]

    Read More