Format Painter in Power BI and other color stuff

How Power BI determines colors can be a bit of a mystery and i seem to spend time on aligning those colors… This was the inspiration of “my” Power Bi Color Theme tool: The Theme Master 500 (named after my Barbecue in Australia!) The reason I am quoting the word “my” is Petr Staníček: Dobrý…


Automatically download and use the Power BI Audit Log

  As you saw in my previous post i have been playing with the Power BI Audit Log to find out which users are using my tenant, when are they doing this and what are they playing with. To do this is pretty easy with less than 10 steps!   Step 1.  Export the Power BI…


April and May Webinars: Power BI Security, Flow Approvals, InfoPath migration, Deploying PowerApps, Marco Russo on Design and more!

PowerApps and Microsoft Flow Webinars   Introducing Flow Approvals: better enable People-based automation Rebuilding an InfoPath Designer form in PowerApps Microsoft Flow best practices and examples for Business Analysts by Jon Levesque Connecting to On-Premises data from PowerApps by Archana Nair And Dimah Zaidalkilani Deploying your PowerApps applications by James Oleinik Look behind the curtain…


Using SharePoint Online or OneDrive for Business to get out of the Power BI “Refresh Game”

My primary role is to ensure a great customer interaction through our website, UserVoice, Webinars, MVPs, User Groups and our two feed back program (In our division referred to as “Fire Starters” and “Advisors”). The best part of this is interacting with YOU…the community.  The worst part is the reporting and the mini fire drills…


Using Flow and Power BI to track social listening through Twitter

My favorite solution template for Power BI is the Campaign/Brand Management for Twitter template that does an amazing job of analyzing your social presence through Azure Logic Apps, Machine Learning and SQL Azure For most my scenarios i don’t need all the bells and whistles of the solution template and Flow provided a very light weight…


Webinars 3/30-5/31 R Script, Marketing Insights, Modeling Deep Dive, New Flow Features, Power BI Embedded and visualization best practices from Marco Russo

Using R Script with Power BI by Leila Etaati In this webinar Dr. Leila Etaati will show walk us through one her favorite topics how to take advantage of R Script with Power BI. This demo rich session will include how to use R script as a data source in Power BI desktop. Register today:…


Pasting into a O365 SharePoint List from Excel

Walking through one of the initial drafts of the the Power of SharePoint paper; one of the first things Michael (the author) has you do is load the SharePoint List from Excel via pasting an entire range. Regardless of what I did;  the directions simply did not work for me!  Turns out to ensure I…


Red, Green, Yellow Icons in Power BI

This week during Avi’s Power BI “Let’s talk Power BI” and the internal Power BI office hours I heard the question “How do i get excel like stop lights in my Power BI Report” If black and white “images” will work you might check out my earlier post: https://blogs.msdn.microsoft.com/charles_sterling/2017/02/10/status-icons-in-power-bi-tables/ If you just need to display…


Setting up availability monitoring for Power BI Publish to Web Results

When running a website you will want to verify all your pages are up and responsive….At a high level this interaction is called “availability monitoring” and while there are several tools that do this; this post will show you how to get availability monitoring using Application Insights against a Power BI publish to web results. Unfortunately by default…


Free: Marketing Insights and determine campaign ROI with Power BI webinar by Ken Puls and Miguel Escobar

  April 6th Miguel Escobar and Ken Puls join me to deliver a free webinar on how to gain Marketing Insights and determine campaign ROI with Power BI   Marketing Insights and determine campaign ROI with Power BI webinar by Ken Puls and Miguel Escobar Understanding your online site traffic, email marketing campaign, newsletter subscriber…