Toronto Power BI, Power Apps, Power Automate User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only
  • 1.  related tables'

    Posted Aug 28, 2020 09:29 AM
    Good morning
    I have been working with Power BI and have limited experience. i am trying to get a relationship between two table to work and seem to be not able to achieve this.
    Is there support available for training and help with specific problems?  I am located in Niagara. 
    Regards

    ------------------------------
    Frank Fenton
    IT Development Manager
    Bayview Flowers
    jordan station ON
    9055627321
    ------------------------------


  • 2.  RE: related tables'

    Posted Sep 03, 2020 09:26 AM
    Hi Frank,

    When I've run  a similar issue the cause was misaligned data types between the two fields that were being used to form the relationship.  The Data type identification functionality isn't always 100% accurate, as it can be thrown by anomalies within a data column.  

    Here's the whitepaper for data types: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types  

    Hope there is some value in it for you.

    ------------------------------
    Nathan Childs
    Information and Analytics Support Analysis
    The Regional Municipality of Niagara
    Thorold ON
    1-905-980-6000
    ------------------------------