Skip to main content

MS Ignite - Power BI: The Developer Edition (DAT341)

some brief notes on what was learnt in this MS Ignite session

Link to session video:

Covered in the session:
  • A feature to publish Power BI Desktop reports to SQL Reporting Services is coming soon!
  • The Power BI Team is working on tiles able to be embedded on a web page and viewed by anonymous viewers.  Will be able to embed entire dashboard at some point.
  • Link for developer information is at the bottom of power BI home page ( 
  • How to extend Power BI using custom visualisations
  • Can embed Power BI Tiles into PowerPoint presentations
  • REST Api's are available to do things like  list all tiles & dashboard & datasets and tables and groups
  • Can find approved custom visuals here:
  • Can't pin custom visuals to dashboards yet.  team estimates late December
  • You can download Custom Visuals inside the Desktop Application by clicking the '...' shown below

My rushed notes:
  • AAD auth: add application, native client app,  enter redirect URI.  Then configure power BI permission on ur new app in azure.
  • Custom visuals: built in d3.js .  pbi service built with typescript using angularJS.

Develop your own visual:
  • Get github account.
  • Fork the powerbi-visuals repo.
  • Get vs community 2015
  • Install git, node.js.
  • Clone copy of ur forked repo.
  • Run npm install.
  • Getting started.  Before debugging.  Right click pbi-visuals > property pages > set to 'no build'
  • You'll mainly be playing in the clients folder in visual studio.
  • Set index.hmtl as startpage. In pbi visuals playground.
  • Plugins capabilities file will need to be updated if you are creating custom visualisations.
Thanks for reading, if you'd like to know more about Power BI, why not check out some of my previous posts:


Popular posts from this blog

Export Group Membership From Active Directory Using Power Query

If you need to export a list of staff from an Active Directory Group, follow these steps.  Allows you to gather all the names & usernames of staff in a particular group and save the information into Excel.

Step By Step How To:
Open up Excel > Power Query TabClick From Other Sources > From Active Directory:(In Excel 2016 this is found under: Data Tab > New Query > From Other Sources > From Active Directory) screenshots from Excel 2016 on left, Excel 2010 w/ Power Query Add-on right A popup will ask you to enter your domain name.  It should already be populated with the correct information but if not, input your companies domain name & Click OK:
In the Navigator that opens up, expand your domain tree and double click group:

You should now see a list of all groups in Active Directory in the Power Query Editor:
In order to find & filter for a specific Group, Click the Down-Arrow for the 'distinguishedName' column > Text Filters > Contains...
Type the name…

HP Laserjet 1022 Printer - Can't Print on Windows 10

If you are having trouble getting your laserjet working on Windows 10, here's how I resolved the problem:

Go to Devices & PrintersFind your printer & go to Printer Properties > Advanced TabSet Driver to: HP LaserJet 1022 Class Driver & ApplyIf HP LaserJet 1022 Class Driver is not available.  download from this site: a test page.

SharePoint Online - Branding with CSS

This post is related to a larger group of posts called Migrate SharePoint to Office 365 - Planning & Steps

I've gone with a Publishing Site Collection so that I can use the 'Alternate CSS URL' in Site Settings > Master Page.

First off, thanks to the following websites which helped get me started: Here's what the end result will look like (if you have the same fonts):

Now for the CSS...

/* Design By : Brett Randall*/
/*     Design Colours: Greens/Greys/Blues */
/*     Last Modified : 28/02/2017*/
/*     Description: CSS to rebrand SharePoint Online Publishing Site Collection that is using seattle.master */

-- -…