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…


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…


Easily create histograms of measures in Power BI

I have been looking to improve the Power BI ideas experience….One way i plan on doing this is “freeing” up votes on ideas that are orphaned duplicates or ideas that just didn’t catch on. In looking at the UserVoice votes, I see most of the votes are “trapped” on ideas that don’t even have a…

0