Controlling the Power BI filter context from within PowerApps

Was looking at the PowerApps Docs on how to control the Power BI Filter context from inside of PowerApps and noticed a couple of issues…Like the references to our internal MSIT servers and angle braces in the syntax…and decided a tutorial might be helpful to help people get started.

This tutorial is using the Dashboard in a day sample data that can be found here: https://aka.ms/DIAD     To make it easier i am starting with the finished version of the report

Step 1. Open the Dashboard in a Day finished report

In PowerBi.com login and select Get Data > Files and navigate to where you downloaded and extracted the Dashboard in a Day samples.  In this example i am using a workspace called “Difinity”;  as the intent is to share this PowerApps application, you would not want do this from “My Workspace”

GetFiles

getfiles2 Step 2.  Pin a visual from the Power BI report to a Dashboard

As the PowerApps Power BI control only supports visuals in Dashboards, we need to pin one of the visuals to a dashboard, in this case I am creating a new one called “PATutorial”.

PinDashboard

Step 3.  Create a Canvas based PowerApp

PA1

Step 4. Insert a Power BI Control

From the insert ribbon choose controls and scroll to the Power BI Tile

PA2

Step 5. Setup the Power BI Control

pa3

Step 6.  Add some buttons to set the filter context

On the Insert ribbon select controls and add a couple (~three) buttons.  Change their Text to that of the manufacturers in the Dash board in a day sample i.e. VanArsdel, Natura and Prium.

pa4

Step 7.  Create and set a variable to used as our filter context

In the OnSelect of each button set a variable to the manufacture name.  In this example we are hard coding the values rather than using the Button1.Text property to make it easier to include the needed single quotes around the manufacturer name.

Set(MyManufacture,”‘VanArdel'”)

pa5

Step 8. Set the TileURL property of the Power BI Control

Select the Power BI control and scroll to the TileURL property then add the section in purple below.  If your buttons don’t work there is a good chance you have added an extra space in the URL and the filter is being ignored.

 

https://app.powerbi.com/embed?dashboardId=18aaea96-cc77-45d6-bc72-19876656c513&tileId=1ff09934-db7e-458f-a670-268fc95d2d74&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVVTLUVBU1QyLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0In0%3d

&$filter=Manufacturer/Name eq ” & MyManufacture

pa6

Congrats you have now created a PowerApp that is hosting a Power BI Tile!

 

Some notes with this example:

If you are looking at the Power BI documentation note there are differences!

https://docs.microsoft.com/en-us/power-bi/service-url-filters

  1. myvar should start with “&” instead of “?” (because there are other URL params ahead of it)
  2. “filter” should be “$filter” (unlike in Power BI directly)

The Tile URL may look something like the following:

https://app.powerbi.com/embed?dashboardId=225c9a6a-86e9-4982-a720-5aa1132d0ff2&tileId=dc9b4418-1b31-43e6-8325-6f2d173f6507&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVVTLUVBU1QyLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0In0%3d” & myvar

 

and your Button OnSelect would have something like the following:

Set(myvar,”&$filter=Store/Territory eq ‘NC'”)

 

 

 

Building a Pilot House for a Pursuit 2350

While finishing the 28th Tiara rebuild, the fuel tank in my “fishing” boat failed putting it out of commission.  In addition to the failed fuel tank I had cracked the acrylic make shift windscreen i heat formed to to fit the frame, the side canvas has failed and the in-deck live well needed to be removed as it would flood, served no useful purpose and added a lot of weight to the boat.  Here is the progress on the Pilot house…with goal to replace the worn out canvas, replace the cracked/make shift acrylic wind screen and radically improve visibility(The original windshield’s top frame was literally right at line of sight).

Here is the current windshield and cracked acrylic top.

20181222_121538

Here is the stock side window (Canvas already tossed) 20181222_122505

Step 1.

The first step was to get out some large pieces of card board and trace out the panels

 

20181222_155818

Based on the card board cut outs i would need a sheet of 6mm hydrotek and two sheets of 3/4″ marine plywood, two gallons of West Systems of Epoxy and some fiberglass cloth…In this picture I also have some honeycomb and a coosa panel…not in the image is the 4 tubes of automotive windshield adhesive that will hold in the the acrylic panels.

20181223_131742

Despite cracking the last acrylic wind screen i went back to acrylic…the reasons being:

  1. Acrylic is actually optically clearer than glass (Also what the new mega yachts are using)
  2. No 3 week wait time/ TAP plastic was open when i wanted to do the work
  3.  In terms of strength: The acrylic panel i broke had no frame, was quite thin and still put up with an amazing amount of abuse ( to break it i had smash through a wave and smash into it with my head…and even then it only cracked where i had drilled holes through it to mount it…these new panels are twice as thick!)
  4. Cost was a push…The scratch resistant acrylic and tempered safety glass was actually the same cost.
  5.   I didn’t go with Polycarbonate as it discolor, will yellow in sunlight, salt will scratch it and it flexes so much as to make it very difficult to seal.

Step 2.

Second step was to cut the 6mm to fit around the acrylic panels and the 3/4″ playwood ~3/4″ of an inch smaller than the panels to create a pocket…like a car.  Then laminating the 6mm and the 3/4 plywood and covering it all with Epoxy and cloth.   So while I may have started with a lot of plywood most of that wood is still in my garage!

20190105_142920

The side windows i mounted the panels in before installing and only removed the protective film from the areas i was putting adhesive.

20190106_110744

As of today I am about 80% finished glassing it all in and waiting for the epoxy to cure.

I will be running AFI 1.5 wiper motors I will be using with 21″ blades and 20″ pantograph wiper arms.

So my rough costs so far are:

  • Plywood $250
  • Epoxy  $200
  • Acrylic panels and cutting $600 (only fronts are scratch resistant)
  • Windshield adhesive $50
  • Fiberglass Cloth …already had
  • Fumed Silica $30
  • Wiper motors $250
  • Wiper Arms $120
  • White 5200 to seal the top to the sides (Bottom is epoxied on) $30
  • Washer Pump $10

So around $1500

 

 

Charles Sterling Biography

Charles Sterling (Chuck) came to Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as a Visual Studio program manager then joined the Power Platform group focusing on Power BI and now continues his community passion and looking after the PowerApps influencers and MVPs.

In his off time Chuck likes to do this own Mythbusters/Roadkill type projects with such as:

To see Charles-Sterling’s 25 years at Microsoft check out his resume

Latest sessions I have been delivering:

An all demo view of Microsoft’s new Power platform

While you are probably already familiar with Power BI, PowerApps and Microsoft Flow; you may not know that Microsoft is bringing these tools together into a unified brand called: the Microsoft Power platform.  In this session Microsoft Senior Program Manager, Charles Sterling will give an all demo introduction to these products AND how you can use these products together with other offerings such as their new database engine called Common Data Service for Apps and Microsoft Forms to create very sophisticated “no code/low code” solutions for Business Analysts and  citizen developers.

If we are going to do this in a two part series:

Part 1. Introduction to PowerApps

Build apps in hours—not months—that easily connect to data, use Excel-like expressions to add logic, and run on the web, iOS, and Android devices.  In this session we will walk through how to get started with PowerApps and quickly build applications that solve business problems quickly and do not a development background using a point-and-click approach to app design and Excel-like expressions. Publish your app to the web, iOS, Android, and Windows 10. It’s that easy.  This session will also cover Microsoft Flow, a powerful workflow automation that integrates directly into your apps with a no-code approach that connects to hundreds of popular apps and services.  Data is at the core of every app. We make it easy to get your data into your apps with more than 200 connectors for many popular cloud services and even your on-premises data.

Part 2. Introduction to Power BI

In this session, Charles Sterling will introduce Power BI, a suite of business analytics tools that takes your data and delivers insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.  Demos to include creating reports, access data from the web PowerApps integration and putting it all together with purpose built Dashboards…all built with every day computer skills.

What is new and exciting in Power BI

With weekly and monthly releases, there are a lot of fantastic new features to explore in Power BI. In this session, we will review what’s been released lately, including the new collaboration features in the cloud-based service, the new authoring and modeling features of Power BI Desktop, new Power BI resources, and finally what’s new for developers leveraging the Power BI platform.

Data Visualization best practices with Power BI Desktop

By the end of this course with Charles Sterling, you gain a better understanding of the best practices and components that influence communicating data visually. Specifically gain familiarity with Power BI report layouts and structure the agile process to creating Power BI data visualizations. Understand the art behind visualizations, implications behind choosing the right charts, the impact of color, shape and size, and finally the use of Power BI custom visuals.


Story Telling with Power BI Desktop

Join Power BI World Tour favorite Senior Program Manager, Charles Sterling as he delves into the data storytelling components of Power BI. By the end of this sessions, you will gain a better understanding of how to communicate data more effectively through storytelling. This all demo session will focus on Power BI Desktop in action (Bookmarks, Q&A, Explain the Increase, Drill Through, Page Report Tooltips) to help you  to tell stories with your data and help users navigate your reports.

Power BI Administration & Governance

Microsoft Power BI administration is the management of a Power BI tenant, including the configuration of tenant settings, usage monitoring, and provisioning of licenses, and other organizational resources. The job is to make business users productive and ensure security and compliance with laws and regulations. This session covers the typical admin tasks and tools, such as Power BI admin portal and Office 365 admin center, and how to automate them by using administrative APIs and PowerShell cmdlets.

Power BI Hands-On Administrator in a Day

Need to come up to speed fast on the administration for Power BI? Then this all day course is for you!

In this Hands on Session, Charles Sterling, is going to walk through the Microsoft Power BI administration and the management of a Power BI tenant, including the configuration of tenant settings, usage monitoring, and provisioning of licenses, and other organizational resources. The job is to make business users productive and ensure security and compliance with laws and regulations. This session covers the typical admin tasks and tools, such as Power BI admin portal and Office 365 admin center, and how to automate them by using administrative APIs and PowerShell cmdlets.  Specific Hands  labs around  using capacities in Power BI, safely sharing Power BI assets and finally using the Power BI audit log to optimize your Power BI Usage.

Community Advocacy and Conference Swag?

I work on a community team and most of my team mates seem infatuated with giving out swag/chachkies.

…And i don’t get it….

Let’s start out with what SWAG and Community are both good for:

  1. Swag > Driving a brand/marketing message.
  2. Community > Creating a connection

If you are in a marketing role releasing a new offering, giving out Swag makes perfect sense. After the event/interaction, those chachkies can potentially remind a would be consumer to investigate the offering.

With community you are cultivating a connection and advocacy…if you have to buy this advocacy with trinkets it is likely going to be short lived and very unlikely to drive any community commitment curve gains.

An Interesting (and accidental) experiment by a team i have interacted with at a large (20K attendees) industry conference was they hosted a booth and gave out chachkies AND had a drawing for a laptop.

Half that team focused on just that interaction…giving out trinkets, answering questions and signing people up to the website.  The other half of the team printed out little fliers and put them on the seats of their presentations where they instructed people how to solve common business problems…With the free samples listed on the fliers.

As you can guess from my introduction the team members that just gave out Swag saw no appreciable climb in their community contribution/growth.  The team members that gave out the fliers pointing out (FREE) samples saw a 300% increase during that conference.

…..HMMM….

Do shirts have a place in community?

Sure!

In looking at the community commitment curve it seems this is an effort best focused at the top and people that want to fly your brands colors while they are presenting etc.

Will it make them work harder? …Unlikely but there is a good chance it may make their interactions more effective or help them start conversations.

BUT WAIT

For people that have seen me present may note the seeming inconsistency that i love tossing out stuff during my presentations….

Worth pointing out, I am just as likely to toss out candy bars as Tshirts AND the effort often involves some sort gamification…meaning i keep track of who gets the most candy bars etc and will introduce myself to this (would-be) advocate after the session.

 

 

 

 

 

Webinar 11/13: Advanced data prep with Power BI dataflows for unified data and powerful insights

Look at the all new Power BI dataflows with Program manager Anton Fritz

Power BI dataflows’ public preview is just around the corner, in this session the product team will introduce you the new and advanced capabilities for data-prep in Power BI.  Preparing and defining ETL for insights is significant challenge for businesses today—ingestion, cleansing, transformation, and enrichment are labor-intensive and time-consuming tasks, which require deep technical skills. Power BI now introduces advanced data prep with dataflows—a suite self-service low-code/no-code features and capabilities for business analysts to easily process and unify their data and store it in Azure-based data-lake storage. With these new capabilities, Power BI offers a solution for any business need—whether you want to prep your data with ease, using a familiar built-in Power Query experience, or to leverage the full Azure stack for more advanced use-cases. Join this session to learn how to easily prep your data, leverage Microsoft’s standardized schema, improve time-to-value, eliminate data silos, and create one source of truth for your organizational insights

When: 11/13 8:00AM PST

Where: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/10-23-18-Webinar-Advanced-data-prep-with-Power-BI-data-flows/m-p/534100

About Anton Fritz

Anton is an experienced program manager, nowadays focused on delivering innovative problem detection capabilities in cloud applications and infrastructure monitoring domain, leveraging machine learning and data mining technologies. Before coming to the Power BI team Anton worked on the Azure Monitoring team, working on advanced detection and diagnostics capabilities powered by ML algorithms for monitoring hybrid workload environments.

Creating the perfect MVP Summit

Was asked to share some thoughts on creating the Perfect MVP Summit.

Every year we ask MVP’s what they want from the MVP Summit and every year the answers are the same:

  • Insight into the product planning

  • Connection with the product team members

Despite this incredibly simple set of directives we still manage to get this turned around.

Luckily for my MVPs I am an incredibly simple person <grin>.

Let’s start with some anti-patterns I see some of my very smart peers doing:

DO NOT ASK MVP’s WHAT THEY WANT TO SEE

Having dedicated much of my career to ensuring the community has a voice at Microsoft why the HELL would i suggest this?

Three fold reasons to not do this:

  1. They have asked to see the product plans…how the heck will they know this?
  2. The MVPs will often ask for technologies we aren’t working on…PG* presentations on these topics are waste everyone’s time
  3. With a 100+ MVPs per track guaranteed they won’t get the content they NOW EXPECT and it is a little like burning presents from under a Christmas tree!

DO NOT USE IGNITE/BUILD AS A SCOPING TOOL

These events are used by marketing to convey a picture of how we WANT the technology to be perceived today…

Image result for marketing reality tree swing

Versus the engineering strategy at Microsoft is what we EXPECT the industry need will be in 5 years.  Most engineering efforts will have large feature efforts in ares we haven’t shipped and the MVPs have never seen…

Our internal conference called TechReady may be a better model/resource but using it can other cause anti-patterns

 

DO NOT HOUND THE FEATURE PMS FOR POLISHED SLIDES

For most conferences preparedness will directly translate to success…why not here?

LESS is More Seriously,

Feature PMs are hired create and ship features (duh) not presentations, so if you hound them into getting you a slide deck early you will likely get some variant of their TechReady, Ignite or BUILD sessions last delivered AND they are vested into presenting AT the MVPs…Exactly what you don’t want.  If you let them run down their own clock they have two choices blow the dust off those presentations anyway or what you want to encourage: Export their backlog to Excel (this what they are working on day in and day out) and pull out their in-flight Storyboards and have a conversation around the stack ranking of the backlog use the storyboards on what they thing implementation could look like.   This very raw delivery ALWAYS be appreciated more AND adds more value to the to the feature team.   Brian Harry is an amazing example of delivering the best MVP sessions…and pretty certain all of his content was created the morning of his sessions.  (remember: never ask questions you do not want the answers to)

So How do I create my MVP Summit agenda? 

Any any organization you are going to have the VP/ or Principal PM; who i typically refer to as: “Da Boss”…This is your track kick off (or track Keynote for lack of a better term).  Da Boss’s session will be to level set how these fit together and the world we see in 5 years.  Under them they will have less then a dozen Group Program Managers who will own 1-2 feature areas under active development…This is your agenda.

 

Image result for sudoku

 

The difficulty arises in picking the right presenter(s) and giving them the correct amount of time.   If you have 20 sessions and 20 feature areas it seems like an easy Sudoku exercise….Unfortunately the world isn’t that easy in the investment of TWO feature may make up ~30% of the dev resources and future investment…and the MVP Summit agenda should reflect that!

 

Area Point Allocation
Keynote/Level Set Arun 2
Dataflow Adi 3
Desktop Kim 2
Service Adam 2
Premium Josh 2
Gateway & Connectors Mahesh 2
AI Richard 2
Flow Stephen 1
PowerApps Ryan 0.5
CDS Ryan 0.5
Excel Ash 1
RS Chris .5
Embedded Nimrod 0.5
Custom Visuals Ranin 0.5
SSAS Christian 1

To be continued!

 

Best Practices

  • *MVP to MVP Day
  • Office Hours
  • Stream the content
  • Conversations over parties
  • MVP In Residence
  • If you are going to do surveys PLEASE ACTION THEM

 

MVP to MVP Day

This is a day that the MVPs organize and deliver the content for.  This way they get to share best practices and cover topics we aren’t actively working on.

…Always interesting to have MVPs deliver to Microsoft best practices for features we had built!

Office Hours

While we try and make the normal agenda be a conversation the reality it is about OUR plans/intentions.  This time is dedicated to an open exchange on those topics in a 1:Few setting

Stream the content

With today’s legislation some of my MVPs can not get into the US for this event.  Streaming is no harder than setting up a web cam and sending a skype meeting request.

…I typically put an MVP on point for making sure the Camera is pointed in the right-ish direction but this is NOT hard nor expensive!

 

To be continued….