skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led Training
      • Overview
      • Guided learning
      • Documentation
      • Webinars
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Galleries
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • MBAS Gallery
    • MBAS Gallery 2020
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Finding a Puppy using Power BI

    Finding a Puppy using Power BI

    09-22-2017 13:03 PM - last edited 09-22-2017 13:05 PM

    RoryBI
    MVP
    729 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    RoryBI
    RoryBI
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Finding a Puppy using Power BI

    ‎09-22-2017 01:03 PM

    Hi All,

     

    We were looking for a puppy recently and when I went onto the UK Kennel Club website I found it a bit bewildering looking at all of the data.  Firstly, there was no map of the uk, and as my geography of the UK wasn't great, this wasn't ideal.  Secondly, the key date people look for when getting a puppy is the the date 8 weeks from birth, rather than the date of birth.  Finally, many of the puppies were either born well into the past or were a bit too far into the future.

     

    The dashboard attempts to address these points and the green dots are those dates that are closest to the centre of the date selectors chosen.  The table updates based on the breed selected and there is a hyperlink to the kennel club website shown next to each owner.

     

    Under the bonnet the M code is reasonably efficient with just 3 fields of data, Breed, URL and Image Url required to enable the scraping of data from the web.  There is a downside in that functions and web scraping are not good bedfellows and so the PBIX will only update from the desktop experience.  There are some ways around this, but none that I found to be particularly efficient.

     

    Oh by the way the image for the Cocker Spaniel is my own puppy - Kylo 🙂

     

    eyJrIjoiODNiZGExMmMtMGExYi00NTI1LTkwYTUtNDc0ZWQ0ODJjYjM0IiwidCI6IjFkOTEwYzM3LWE0MjktNGYzNS1iYTFiLTM3ZDViMjNmZTRhMSIsImMiOjh9

    Preview file
    1465 KB
    Puppy Finder with Function.pbix
    Labels:
    • Labels:
    • Lifestyle
    Message 1 of 1
    729 Views
    0
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Preview Exit Preview

    never-displayed

    You must be signed in to add attachments

    never-displayed

    Additional options
    You do not have permission to remove this product association.
     

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    • © 2021 Microsoft
    • Follow Power BI
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks