Bluewater Season Calendar

Added as a prop for a Power BI session on how to get data from a web page.  Learn where to go for some of the best saltwater fishing experiences below. Saltwater fish have always been a bountiful legacy in the waters surrounding our lands. Blue water game fishing received world wide acclaim after Zane…


Format Painter in Power BI and other color stuff

(If you want to see the color tools in action be sure to check out my @GuyinaCube video: https://www.youtube.com/watch?v=ECaa_vqSwTI) 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…


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.   If you haven’t seen the Power BI Audit Log in the wild it looks like the following: To…


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…


Updating your Excel and CSV datasets to point to SharePoint Online

(Removing and Automatic refresh and OneDrive from the title as just had somebody point out that i didn’t include the OneDrive directions and actually didn’t walk through that path for this effort.)     My primary role is to ensure a great customer interaction through our website, UserVoice, Webinars, MVPs, User Groups and our two…


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…