About Me

Devin Knight a Microsoft Data Platform MVP and the Vice President of Training at Pragmatic Works. He is an author of eight SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the a contributing member at the Jacksonville Power BI User Group.


  1. Hey Devin, just watched your PowerView recording from SQL Pass last fall. I thought you’d enjoy reading my notes and things I found of interest from your session. Also, I think I’ll reference you in a blog post. Do you want to know when I do that? I’ll link to your site, so you get some SEO credit from it.

    Requires SQL 2012

    5 different Microsoft reporting tools

    PowerView – End Users
    If they can click a button than they can use PowerView
    End User Tool
    Everything just talks to each other and there’s no need for developer work
    Create fancy reports off of data models
    SSRS – Report Designer & Report Builder – Developers
    Developer Tool
    Static Report
    PowerPivot – Developers & End Users Combined
    Power User Tool
    Need to create relationships
    In Memory OLAP
    Ad hoc
    Excel –
    End User Tool
    Ad hoc Reporting Tool
    Performance Point – Dashboarding tool as part of SaharePoint
    Developer Tool
    Score cards

    what is power view?
    ad hoc reporting tools…excel pivot tables on crack

    his decision matrix on when to use which tool


    do the same things they can do in pivot tables, but bring in images and charts

    tool is targeted towards end-users


    download excel 2013 to see excel 2013 power view, released to manufacturing fall 2012

    requires silverlight 5

    can use BISM tabular model or standard multi-dimensional cubes (new feature)

    optimizing a data source for power view may deoptimize it for other reporting tools and other olap clients

    excel 2013 has power pivot on it all ready without a download

    he recommends watching 7 steps to getting kerberos right session (i think it’s chuck’s session)

    DAX is supposed to be as easy as Excel formulas

    DAX has really good intellisense

    the scatter chart animation was a really cool demo – about 60 minutes in

    the filter at 1:04 is also pretty cool

    click to interact inside powerpoint is way, way cool…way better than using screenshots of reports

    drillthrough to MOLAP might be in the next release

    MOLAP cubes relationships will come through

  2. Good evening my dear, I read your site and am interested to exchange ideas on the Power Map, here in Brazil few use, it is an extremely powerful tool. I use it every day to estastísticas of accident rates, but I wonder if there are new recuros within the power map so I can enjoy. Below is my contacts:
    Whatsapp: 03598291801
    Whatsapp1: 06296060114
    E-mail; brunosilver@outlook.com – or – bruno.silva@triunfoconcebra.com.br

    Big hugs.

  3. I attended your Advanced power seminar in pragmatic works. I have a simple question how do I fix the following problem ?

    Formula.Firewall: Query ‘ACCIDENT DATABASE’ (step ‘Added Custom’) is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.

  4. We have an SaaS app called Aluvii.com. We’d like someone to implement PowerBI embedded from start to finish into the app. Do you do that type of work?

    1. Hi Salam. The course materials is something that’s provided with the paid version of the class that was mentioned during the session. Let me know if I can direct you do that.

  5. Hi Devin,

    My name is Sophie. I’m an Excel and Data Platform MVP in Montreal, Quebec (Canada). I’m also the leader of the Power BI user group in Montreal.

    We are now planning our next year of meetings and we would love to have you as a speaker. Unfortunately, we do not have any budget but we do have a nice crowd (82 persons at our last meeting).

    Is it something that you would be interested in?

    Please, let me know.


  6. Hey, Devin,

    I sent out this link to my company team, and to the FISG (Florida IT Server Group) . . . you probably already have it somewhere – it’s Eric Ligman’s 2016 collection of free eBooks from Microsoft . . . and there is A LOT of SQL and Power BI docs and guidance available:


    BTW, I enjoyed your recent presentation to Jax FISG on Powershell . . . which was one of the TWO technologies that was identified by Mark Minasi at the Tampa IT Pro Camp that would be wise for IT pros to learn. He indicated there are some features on Windows Server 2016 that aren’t even available thru a GUI – exposed only thru Powershell. The other technology was CLOUD (Azure) . . . which, coincidentally was the beginning and end of YOUR presentation.

    Hope you and your readers enjoy.


  7. Hi Devin

    great series about Power BI custom visuals. You may want to review IBCS Charts as well? I can provide a trial version.

  8. Devin, I just came across your Power BI custom visuals series. Although I am a relative beginner in learning Power BI, I look forward to applying the visuals when I get there. By any chance, would you consider including the custom visuals which are available only on Github? I briefly looked at a couple, but I do not understand how to convert the code to a file which is importable into Power BI.

  9. Hi Devin,

    I attended the PowerBI Takeover class and had to leave early so I didn’t get to ask my most pressing question. I watched the video yesterday and was hoping there would be an example of how to do a simple dynamic axis using the following:

    1) Disconnected Data Set (ex: Region Level … Region, Area, Site)
    2) Single Select Slicer to select the above
    3) Custom Column (ex: Show Region, Area or Site Name based on the Single Select Slicer value)

    I was able to get the first two and a measure to do the third but I need a column so I can use the column in a visual as an axis.

    Any assistance would be appreciated.

    Thanks – Ryan

    1. Hi Ryan. I’m not sure I understand. Are you saying you’re trying to put a measure on the visual axis? I think I may be misinterpreting something! 🙂

  10. Devin, I am a fan. I have been in live training with you a couple of times–THANK YOU! I am currently viewing Advance Power BI Takeover. When I try a simple query folding, I am not able to view native query. I have a connection to a D365 CRM Account table. I have filtered the City for a single city name. The Filtered Rows step is the only step after Source and Navigation. When I right click the step, Native Query is grayed out. I have had this problem with other workbooks. Am I missing something?

    1. Hi Sharon. Unfortunately there’s not an official list of sources available (that i’m aware of) detailing which data sources can be folded. It would surprise me if D365 cannot be folded but it certainly sounds like it. Can you test with a different type of source, like SQL Server, and see if the folding option appears again?

  11. Caught your intro to the new book yesterday and picked up a digital copy. While reading it something jumped out at me that is in error. In the second chapter you state that the icon to change a column type is to the right of the column name – that is incorrect – it’s to the left.

  12. Dear Devin,
    On June 18, 2016 you hosted a Power Bi presentation at SQL Saturday at Nova University in Ft Lauderdale.

    I want to thank you personally for opening this world to me, it changed my life and my career.

    I also learned SQL as part of the process of implementing Power Bi at the company I work for, this combo skill set is in super high demand now and you motivated me to get certified in Power Bi and SQL querying.
    Thank you for everything you do and sharing your knowledge,
    Kevin Mason

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s