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

How to delegate the Power BI Administrator Role via to the Office Administrator Portal

In October we added the ability to make it easier to administer Power BI with the Power BI Service Administrator Role. https://powerbi.microsoft.com/en-us/blog/making-it-easier-to-administer-power-bi/  The documentation showed how to add this via PowerShell; today i was  asked for a pictorial walk through of adding a User to the Power BI Role via Office Administrator Portal which can…

0

Free Power BI ebook by Reza Rad: Power BI From Rookie to Rockstar

I truly have the best job at Microsoft: Make our customers happy, specifically through community channels. What does that entail on a daily basis?  Looking at the telemetry from our support cases, assist our user group leaders with their group efforts, and my favorite part work with our MVPs.   These people are basically super hero’s…

0

Coloring an entire state in Power BI

Was asked during today’s Power BI User Group leaders call how to fill in an entire state with a color based on a measure. Turns out the shape map makes this pretty pretty easy and since a picture is worth a 1000 words have decided to save myself some time and create one with a…

0

Power BI, Flow and PowerApps Webinars Feb 23-April 6th

The next two months we have an all star set of Webinars for your viewing and listening pleasure! If you haven’t attended one of the FREE Business Application Platform webinars the intent is to offer world class best practices giving you not just insight into your data but also how to action and automate your…

0

Status Icons in Power BI Tables

Have had a couple of requests for people asking how to have Icons instead of the Measure actual values in a Power BI Table.  While this isn’t available directly in PowerBI one of our MVPs wrote a great blog post on how to do this with R. http://sqlkover.com/dynamically-changing-shapes-in-power-bi/ Turns out you can also get some…

0