Salem Area SQL User Group

Next Meeting




Peter Myers -- The Do’s and Dont's of Power BI Relationships

  • In-Person @ Salem, Oregon, United States (map)
  • 12:00 - 13:30 (UTC-08:00) Pacific Time (US & Canada)
  • Language: English

SalemSQL Lunch & Learn
*Monday, February 10th, 2020, 12:00 pm to 1:30 pm
Event Sponsored by TEKSystems
RSVP at Eventbrite

*Please note the adjusted day and time for this month’s special guest speaker: Peter Myers from Melbourne, Australia

There will be no meeting on Wednesday February 12th, but our regular schedule will resume next month with a presentation from Arnie Rowland on the Second Wednesday in March - March 11th, 2020, 11:30 am to noon. 


Public Service Building
(Across the street from the state Capitol, the SE building on the Capitol Mall)
255 Capitol St NE, Salem, Oregon 97310, Basement Studio A

Join our LinkedIn Group at: or follow us on Twitter @SalemSQL

<<<Download January Presentation Materials: here>>

<<<Download February Presentation Materials: here>>

Featured Presentation:

The Do’s and Don’ts of Power BI Relationships

Peter Myers, BI Expert Bitwise Solutions

This presentation is about Power BI modeling with a specific focus on relationships. Relationships are essential to delivering intuitive, accurate, and optimal models. In this presentation, learn what relationships do and how they can be configured for Import, DirectQuery, and Composite models. After a straightforward introduction, theory and demos will progress beyond the basics to explain how to achieve sophisticated model designs that include role playing dimensions, many-to-many relationships (two techniques), ambiguous relationships, virtual relationships, and disconnected tables. The DAX functions that leverage or modify model relationships are also introduced.

About Peter:
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services. He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.



Back to Top