Getting the Simrad NSS8 to receive AIS and DSC

 

Finally getting my Pursuit back the water and realized that neither Simrad: NX40 nor NSS8 is communicating with my Standard Horizon 2150.

…I know the NX40 has a couple of issues but got the NSS8 working on the other boat.

Then i remembered this was a replacement NSS8…and all my settings would have been lost.   After a quick search i found the very very good Standard Horizon documention (see below) but those were the settings were still on the radio from before i parked the Pursuit.

http://www.standardhorizon.com/downloadFile.cfm?FileID=7527&FileCatID=86&FileName=Wiring%20to%20SIMRAD%20NSE%20%26%20NSS%20to%20GX2150%20%282%29.pdf&FileContentType=application/pdf

SH

After a LOT more searching turns out the Simrad defaults to not transmitting NMEA and that too needs to be turned on…and the settings changed to match the 2150

http://www.simrad-yachting.eu/globalassets/lowrance/manuals/dansk-manual/nmea-0183-til-nss–hds-gen-3-enheder-brugermanual-skandinavisk.pdf

simrad2

Related Posts:

 

https://sterlingsdotlife.wordpress.com/2015/04/27/displaying-a-buddies-boat-on-a-simrad-nss-8-using-standard-horizon-21502200-and-dsc/

https://sterlingsdotlife.wordpress.com/2012/01/16/displaying-dsc-information-with-a-standard-horizon-chartplotter/

https://sterlingsdotlife.wordpress.com/2012/01/16/how-to-wire-your-dsc-vhf-to-a-nmea-0183-chartplotter-so-you-can-remove-them/

https://sterlingsdotlife.wordpress.com/2011/11/28/displaying-ais-data-on-a-simrad-nx40-using-a-standard-horizon-matrix-2150/

 

Microsoft Business Application Summit Power Platform Workshop

 

Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application.

Step 1.  Create an app workspace to host the application. 

To do this: Log in to PowerBI.com and click on Workspaces > New Workspace.

For people doing this at Microsoft Business Applications Summit we have created accounts for you to use with the names MBASUser201@Powermvps.com through MBASUser400@Powermvps.com (Yes we have 200 people signed up!!) …I will give out the Pass word at the event.  As I used the name MBAS please name yours MBAS### with the number being your assigned account.

SCOREBOARD1

Step 2.  Navigate to the Workspace content view

SCOREBOARD2

Step 3.  Create a streaming dataset

Click on create and select streaming Dataset

SCOREBOARD3

Step 4.  Set the streaming dataset to be API based.

Click on API and select Next

SCOREBOARD4

Step 5.  Set the streaming dataset properties

Add the fields:

Score > as number

Person > as Text

Contest > as Text

Date > as DataTime

SCOREBOARD5

Step 6.  Create a report displaying the streaming dataset

Select Datasets and then select that chart glyph for the dataset you just created in the above step

SCOREBOARD6

Step 7.  Add a visual to display the score by Person

Drag the Score field to the Power BI report design canvas.  This should default to a clustered Column chart, if not change it one and add the person as the axis.

SCOREBOARD7

Step 8.  Pin the Column Chart to a Scoreboard dashboard.

Click the push pin glyph in the visual you just created and save the report with the name “Scoreboard”

SCOREBOARD8

Step 9.  Create a new Dashboard

Select New dashboard and give the dashboard name “Scoreboard” and click pin.

The reason for using a dashboard rather than a report is the fact that reports are not real time yet. (written 6/3/2019).   Do NOT navigate to the dashboard yet. 

Scoreboard9

Step 10.  Adding a PowerApps to the Power BI Report (using the PowerApps custom visual)

In the Power BI visuals section click the ellipsis select the “Import from marketplace”, search for PowerApps and select the visual “PowerApps (Preview)”.

SCOREBOARD11

Step 11.  Creating the PowerApps application with the Power BI custom visual.

Drag the fields Contest, Person and Score to the PowerApps custom visual.

SCOREBOARD12

Step 12.  Add a Rating control to the PowerApps application

SCOREBOARD14

Step 13.  Add a Button control to the PowerApps application

SCOREBOARD15

Step 14.  Add a Text Input control to the PowerApps application

SCOREBOARD16

Step 15.  Add a Label control to the PowerApps application

SCOREBOARD17

Step 16.  Creating a new Flow and attaching it to the PowerApps button

SCOREBOARD18

Step 17.  Add the Power BI Action to the Flow

SCOREBOARD19

Step 17.  Add the Power BI action to the Flow.

Set the workspace to the workspace you created in step one i.e. MBAS####.

Set the dataset to “Scoreboard” that you created in step #5.

The table will be called “Real Time Data” (this set automatically)

SCOREBOARD20

Step 18.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.

SCOREBOARD21

Step 19.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD22

Step 20.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD23

Step 21.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD24

Step 22.  Save your Flow

Now save your Flow.  While not done in this screen shot it is recommended that you name your Flow by default called “from PowerApps” before saving.

SCOREBOARD25

Step 23.  Connect your button to the Flow

Navigate back to the PowerApps tab and select the Flow you have saved in the step above.  This will add a parameter to the Flow call for every field in the streaming dataset.

SCOREBOARD26

Step 24.  Supply the Flow parameters

Set the score flow parameter for score to value property of the Rating1 control.  Set the person parameter to the TextInput1.Text control property.  Set the contest parameter to the harded coded string “MBAS”.  Set the Date parameter to “Now()”.

SCOREBOARD27

Step 25.  Save the PowerApps application

Under the file menu select “Save”

SCOREBOARD28

Step 26.  Save the PowerApps application (cont)

Name your application and select the “Save” button in the lower right hand corner.

SCOREBOARD29

Step 27.  Pin the PowerApps application to the dashboard to the Power BI Dashboard.

Navigate to the Power BI Tab.  You will notice the application is already visible in the Power BI.  In the upper right hand corner of the Power BI visual select “Pin visual”.

Select the “Scoreboard” dashboard created above.

SCOREBOARD30

Step 28.  Test the PowerApps/Power BI integration .

In the Power BI Dashboard type a persons name and select a score.  Hitting the button should update the column chart created above.

finished

Congratulations you have created a streaming dataset, a PowerApps application and a real time dashboard!

Meet Community stars at Microsoft Business Applications Summit

One of the primary reasons people go to conferences is to meet the presenters.

At the Microsoft Business Applications Summit (MBAS), we have an entire “Ask the Experts” experience to make this easy.

We have created a community lounge and will be scheduling a subset of those community stars for you to interact with. Here are some highlights of the community members and topics you will find at this year’s MBAS.

 

Starting and Running a World Class PowerApps User Group by Keith Whatling

In addition to being a PowerApps MVP and one of the earliest/best PowerApps developers, Keith Whatling also started one of the first (and just recently recognized as one of the best) PowerApps user groups on the planet. Keith will be discussing the tactics that helped him in his community journey.

See the source image

Keith Whatling is an experienced analyst with a demonstrated history of award-winning innovation in transportation. “I have a wealth of experience from digital content creation and data analysis to Microsoft’s Power Platform, using PowerApps and Flow to drive digital transformation. I can hold my own with Python, VBA and have some C# experience.”

 

Collaboratively Organizing One of the Largest Power BI Groups by Prathy Kamasani

Prathy Kamasani helps organize one of the largest Power BI user groups in the world and in this session she will share with the community how she manages this process and continues growing their membership.

See the source image

 

Prathy Kamasani is a Microsoft Valuable Professional (MVP) working as an independent MSBI contractor based in London. She specializes in Power BI, SSIS, SSAS and SSRS. Prathy is active in the Microsoft Data community as a speaker, volunteer, and organizes the London Power BI User Group.

 

Running the Largest Power BI Community Site in the World by Mike Carlo

In addition to co-managing one of the most successful US Power BI user groups, Power BI MVPs Mike Carlo and Seth Bauer also manage to find time to host the largest Power BI community site in the world. Wondering how? Then this session is for you!

See the source image

Mike is a user group leader and frequent conference speaker that is Passionate about data, analytics and helping people learn same has developed a website knowledge repository for all things PowerBI, (www.PowerBI.Tips). This site is uniquely set up for people to read and learn about data modeling and visualizations within Power BI with over 60 kudos to date!

 

How to Leverage the Microsoft Communities Platform and Grow to a Super Community by Seth Bauer

In addition to co-managing one of the most successful US Power BI user groups, Power BI MVPs Seth Bauer and Mike Carlo also manage to find time to host the largest Power BI community site in the world. Additionally, Seth Bauer finds the time to answer many of the Power Service questions in the community forums. Find out how he gets his information.

Bauer_Seth-1

About Seth Bauer

I am a Director of Business Intelligence at Syndigo. I’m a Microsoft Data Platform MVP (Power BI). I’ve been working with the Microsoft stack for over 10 yrs, but my major focus area now is Power BI, and sharing what I’ve learned with the User Community. I am a Microsoft Certified Professional, a co-leader of this Microsoft Power BI User Group, and a PUG Board of Advisors member. I enjoy working with clients across the Midwest implementing BI / Power BI solutions.

How to use Microsoft Forums to Learn DAX by Phil Seamark

Author, conference organizer, User Group leader, MVP Alumni, and now Microsoft employee, Phil Seamark is recognized as one of the foremost DAX experts. He recently confided in a community gathering that most of what he learned in DAX was through his participation in community forums. In this informal get together, discuss with Phil his techniques for leveraging community forums into his incredible resume of experiences.

See the source image

Philip Seamark is an author, Microsoft Data Platform MVP employee of the Power BI CAT Team, and an experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft B.I. stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. He has 25+ years experience in this field and is an active member of Power BI community. He is a Super User with 1,945 answers and 590 kudos on the community website http://community.powerbi.com

 

The Value of Joining the Dynamics Online Community by Fawad Khan

Strategy and operations leader with 15+ years of experience managing businesses from $10-20M and leading global IT teams of 100+. “I have helped deliver over $5M in cost savings in Service Delivery along with a 5% improvement in Customer/Partner Experience.” Fawad is a Digital and Cloud Computing strategist in today’s world of AI, Machine Learning, IoT and Hybrid Computing.

See the source image

https://www.linkedin.com/in/fawadakhan1/

 

The Magic Around Delivering an Amazing Presentation by Mico Yuk

Based on requests and feedback on her story-telling presentation, Mico has agreed to share with the community her best practices on delivering an amazing presentation.

Mico Yuk (@micoyuk) is the founder of BI Brainz (the leader in enterprise visual storytelling) and the BI Dashboard Formula (BIDF) methodology. She has trained thousands globally on how to use the power of data visualization strategically to enhance the decision-making process. In the last nine years, her company has worked with Fortune 500 companies like Procter & Gamble, Honda, Kimberly-Clark, Royal Dutch Shell, Nestle, Qatargas, Ericsson, and FedEx. She has also authored Data Visualization for Dummies (Wiley 2014).

 

The Art of Creating a Microsoft Flow Presentation by Kent Weare

Kent Weare is an experienced leader who possesses strong technical skills. Passionate about architecture with a specialty in integration, he is recognized by Microsoft as an Integration MVP.

Kent, a graduate of the University of Regina, has 10+ years of IT experience. This experience includes working on projects for Provincial and Federal Governments, a multi-national bank in the United States, Health Care projects in Eastern and Western Canada and he is currently employed by a large Electricity Distribution company in Calgary, Alberta, Canada.

Kent started working with BizTalk in 2004 and has experience with BizTalk Server 2004/2006/2006 R2/2009/2010.

 

How to Use Community to Make the World a Better Place by Shannon Lindsey

Shannon Lindsay of the Informatics Team at the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) runs the Power BI User Group (PUG) community in Washington, DC. Her associate, Stephanie Bruno, runs the PUG in Pittsburgh, PA. They also run an internal PUG at EGPAF in which they invite all countries to meet (via conference calls) to share resources and ideas and collaborate on projects.

In this session, Lindsay will share her story of how “Community has been the key to our success in relation to the implementation of Power BI (among other technologies) here at EGPAF. In fact, it is because of our relationships with the community that these trainings happened at all! Stephanie heard about the Microsoft MySkills4Afrika program a few years ago from a volunteer at the Data Insights conference in Seattle.”

See the source image

Shannon Lindsey is a data and analytics professional specializing in collection, management, and use of targeted data for program improvement and strategic decision making, solving problems for non-profit and government.

 

What It Takes to Be a PowerApps Flow MVP by Anton Robbins

Discuss with Anton his journey and experiences in becoming a Microsoft PowerApps MVP.

See the source image

Anton Robbins is the CTO of Seisay IT Solutions, a PowerApps and Flow MVP, PowerApps Champion, DC PowerApps User Group Leader and slayer of bow ties. That he has a passion for the Microsoft Power Platform (Flow, Power BI, and PowerApps) communities is an understatement. “It takes a community to elevate technical brethren.” When he is not speaking at an event, he is usually volunteering or organizing events. He has been, in the past and currently is, a speaker at Microsoft conferences and local User Groups. In his spare time, which he rarely has, he likes to roller skate.

Becoming a Community Super User by Gilbert Quevauvilliers

While there are roughly 500 Business Applications MVPs including Power BI, Dynamics, PowerApps, and Flow, there are fewer than 50 community super users who answer the unanswerable questions in the Microsoft forums. Gilbert Quevauvilliers will share his process for getting this knowledge and how to best use the Microsoft forums.

Image result for gilbert quevauvilliers

“Currently, I’m working as a Power BI & Data Analytics Consultant. I have over 10+ years’ experience working with data of any size and any source. By leveraging my skills, I am able to provide insights into customers’ data quickly and efficiently. And this has enabled my customers to gain a better understanding of their business. Which relates to better sales, or significant cost savings.

“I was recently awarded a Microsoft MVP award for Power BI. Power BI, in my opinion, is the logical choice for creating insights, being cost-effective and providing dashboards and reports on Web, Mobile, or in Apps out of the box.

“I have proven competencies in the implementation of data analytic solutions from the ground up, which included developing data warehouses, SSAS Cubes and, most recently, Power BI solutions for customers in various business sectors.

“I have worked within teams, managed teams, as well as worked alone on various successful data analytics projects.

“I have focused on providing Power BI Solutions to customers since the inception of Power BI in July 2015.”

https://www.fourmoo.com

 

Demystifying the MVP Process by Julie Yack

In addition to running a Dynamics User Group conference, Julie Yack is one of the most distinguished of the Dynamic MVPs. In this informal get together, Julie will be happy to field any questions about the MVP program and nomination process.

See the source image

Julie Yack is a Colorado-based Microsoft Dynamics CRM MVP serving clients across the globe, providing training, implementation, analysis and insight for companies wanting to take their service to the next level. Julie’s blog, http://www.julieyack.com addresses pertinent topics of the day, ranging from Dynamics CRM to technology in education to travel to voting rights.

 

Lounge Hosts

This all-star community will be joined by the entire Microsoft community team with members like Charles Sterling, Jon Levesque, Brian Dang, and Purvin Patel.

Jon Levesque

See the source image

Jon Levesque is an entrepreneur and strategist with an expertise in brand engagement, community building and creating winning evangelism strategies. He is a Senior Program Manager on the Microsoft Flow product team focusing on helping Flow evangelize the product and how to use it, helping customers understand the platform and its benefits.

Jon’s background has ranged from project management to customer experience, to support and marketing. He has over 12 years in the industry and has helped lead community and engagement efforts in the low code/no code space since its inception. He has worked with large brands like Microsoft & HTC and smaller, local brands like Forterra NW Inc, as well as musical artists like Jethro Tull & DJ Nano.

As a speaker and educator, Jon has created the first Microsoft Flow EdX Course, The official Guided Learning material for Microsoft Flow and Ehang Drones and also created a series of YouTube videos guiding users on how to transform business process digitally using Microsoft Flow.

Brian Dang

See the source image

Brian Dang now a program manager on the PowerApps team is helping shape the product to make it easier to use and adopt the world of citizen developers. Formerly a third and fourth grade teacher, Brian Dang (known as Mr. Dang by his students) used PowerApps to create several education apps for teaching, managing his classroom, and gamifying the learning experience. In this in-depth interview, Brian shares his experience meeting Bill Gates, how he got started with PowerApps, how students and teachers are using apps in the classroom, and his vision for PowerApps in the education space. Teachers and students are very excited about using apps in the learning process. Not only do the kids get engaged in the subjects they are learning, but they also explore the technology and authoring tools used to create the custom apps, like the spelling and banking apps. His fourth graders even collaborated in teams to create their own apps, such as one with a Harry Potter theme. Since recording this video, Brian has joined the PowerApps team to execute his vision of bringing PowerApps into the classroom and enabling teachers, students and administrators to “not settle for the apps they have, but create the apps they want.”

May 2019 updates for Microsoft PowerApps

For people that can not wait here is a mid-month roll up for all the new features we have shipped in PowerApps for the month of May.  Please note when the month is over i will publish this on the product blog:  https://powerapps.microsoft.com/en-us/blog/

Also To see what was new in April for PowerApps be sure and check out:

April 2019 updates for Microsoft PowerApps

Import Canvas app components from cloud apps

Components just go better!  With this update, you can share components using cloud apps.

https://powerapps.microsoft.com/en-us/blog/import-components-from-cloud-apps/

Provisioning and administration is getting easier

Now you have a single place to manage and visualize the  storage of your organization. Check your organization storage capacity here. Read more here.

https://powerapps.microsoft.com/en-us/blog/provisioning-and-administration-is-getting-easier/

 

Owner, Customer, and Regarding for canvas apps

Common Data Service polymorphic lookups are now available from canvas apps.  You can now:

  • Access, set, and filter on the Owner field of any record.
  • Access and set the Company Name field (a Customer data type) of the Contacts entity.
  • Access and set the Regarding field of activity entities such as Faxes, Phone Calls, Email Messages, etc.
  • Access the list of all Activities for a record.
  • Access the list of Notes for a record.

https://powerapps.microsoft.com/en-us/blog/owner-customer-and-regarding-for-canvas-apps/

 

On-premises data gateway May 2019 update is now available

The On-premises gateway now features monitoring gateway usage and performance. Traditionally, for monitoring performance, gateway admins have had to depend on manually monitoring performance counters through the Windows Performance Monitor tool. This feature is an out of the box feature which includes additional logging regarding queries and system counters along with a Gateway Performance PBI template file to visualize these. This would insights into gateway usage and allow troubleshooting slow performing queries.

https://powerapps.microsoft.com/en-us/blog/on-premises-data-gateway-may-2019-update-is-now-available/

PowerApps Canvas App Accessibility Guidelines

accessibility

This white paper is for the enterprise application developer (maker) responsible for designing, building, testing, deploying, and maintaining PowerApps in a corporate or government environment. This white paper is a collaborative effort of the Microsoft PowerApps team, Microsoft IT, and industry professionals. Adherence to the guidelines and standards in this document will assist developers in making their PowerApps canvas apps accessible to all app users.

https://thriveproduct.blob.core.windows.net/thrivedocs/PowerApps%20Accessibility%20Standards%20and%20Guidelines.pdf

 

Performance enhancements to the PowerApps portal

we have built and are deploying a new UI framework that significantly reduces the number of calls and download size of PowerApps.

https://powerapps.microsoft.com/en-us/blog/the-powerapps-portal-is-now-significantly-faster-to-load/

 

Add new fields while creating your canvas app

While creating apps using the Common Data Service, makers select an entity as the data source and bind it with data controls. This allows them to add fields in the selected data source to a gallery, data table, or form. This is good for fields that are already present in the data source. However, if there is a need to add an additional field, the maker would need to save the app, switch to the entity designer to add the additional field before returning back to the app. This results in unnecessary deviation from their original goal of making an app.

Adding new field in Entity Designer

https://powerapps.microsoft.com/en-us/blog/add-new-fields-while-creating-your-canvas-app/ 

Extend the power of WYSIWYG Model based form authoring to quick create and quick view forms

The new form designer now supports authoring quick create and quick view formsAll the beneficial features of the new form designer such as WYSIWYG preview, enhanced fields pane, quick-access property pane, tree view and more now extend to quick create and quick view form authoring to help enable a rich and productive experience.

Quick create form as it appears to end-users

https://powerapps.microsoft.com/en-us/blog/extend-the-power-of-wysiwyg-form-authoring-to-quick-create-and-quick-view-forms/

 

Announcing general availability of Model based Apps Solution Checker

To deliver on complex business requirements, model-driven app makers often can end up with highly advanced solutions that customize and extend the Common Data Service platform. With advanced implementations comes an increased risk where performance, stability, and reliability issues become introduced, which can negatively impact the user experience. Identifying and understanding how to resolve these issues can be complicated and time consuming. With the solution checker feature, you can perform a rich static analysis check on your solutions against a set of best practice rules and quickly identify these problematic patterns. After the check completes, you receive a detailed report that lists the issues identified, the components and code affected, and links to documentation that describes how to resolve each issue.

Install solution checker

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/use-powerapps-checker 

 

Please note this is a work in progress and I will continue adding new features through out the month.

Also To see what was new in April for PowerApps be sure and check out:

April 2019 updates for Microsoft PowerApps

https://powerapps.microsoft.com/en-us/blog/april-2019-updates-for-microsoft-powerapps/

 

 

Sharing PowerApps at scale made easy

Last week on the April PowerApps community call one of the viewers indicated the process to share their PowerApps application with ~600 users wasn’t as fast as they wanted.

In digging into what they were doing it turns out they were trying to add 600 people directly is the application sharing dialog (Note: PowerApps only supports adding 200 identities at a time).  In addition to being slow this a security anti-pattern as typically you don’t grant people to resources; you grant security groups access to resources and add people to the security groups.

Luckily sharing at scale with PowerApps can be simple!

Here are the steps to make your PowerApps sharing experience a lot easier -and more secure.

Step 1. Create an Active Directory security Group.

You can either do this with PowerShell using the New-ADGroup or manually.   Since you don’t tend to create a lot of security groups; including the manual steps below.   Note while this is done through the Azure portal an Azure subscription is NOT required!

1. Navigate to https://portal.azure.com and select the Azure Active Directory Blade.

AAD

 2. Select Groups

aad3

3. Supply the security group details…and possibly add members.  Likely you will find it easier to add your members with PowerShell as it is something you will find yourself doing all the time….particularly after people find out how fun it is to use PowerApps!

aad4

Step 2. Share your PowerApp with a security group.

Sharing with a security group is just like sharing with a user…i.e. type in the name of the security group created in step 1. and select the access permissions those users should receive.

aad5

3. (Optional) Add members via PowerShell

While you can add security group members directly in the Azure portal, I find it much easier to actually keep track of my members in a dedicated file like CSV – and add them via PowerShell command: Add-ADGroupMember with an example here: 

Using Add-Adgroupmember and CSV Files

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