Forum Discussion

EZimmet's avatar
EZimmet
Resolver I
5 years ago
Solved

Unable to Relate to another Table

Unable to Relate to another Table   I have a visual that shows fields from various tables but when exporting the data and underlying data the field from Table #3 does not Export.   If a table is ...
  • v-jingzhang's avatar
    5 years ago

    Hi EZimmet 

     

    Which operation were you doing when you saw the message "The column 'Company[Name]' either doesn't exist or ..."? Do you use the RELATED function? If so, it has some limitations. Some of them are:

    • The RELATED function can only be used in calculated column expression.
    • The RELATED function cannot be used to fetch a column across a limited relationship

     

    And there are many considerations and limitations when exporting data from visuals. Check if your model and data hits any. Some of them are:

    • Export using Underlying data won't work if you enable the Show items with no data option for the visualization Power BI is exporting.

    • If the visualization uses data from more than one data table, and no active relationship exists for those tables in the data model, Power BI only exports data for the first table.

    • Export using Underlying data won't work if:

      • the tables in the model don't have a unique key.

     

    Please check above links first to troubleshoot this problem. If you still cannot fix it, let us know more details about the problem. 

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.