Forum Discussion

Leonid_Kostin's avatar
Leonid_Kostin
Icon for Advocate I rankAdvocate I
6 years ago

RELATED function doesn't work

Hello, Power BI experts.   I've found myself in the strange position. After the July 2020 update some of my Direct Query report have broken visuals. The strange thing that I haven't changed anythin...
Need Help
  • Leonid_Kostin's avatar
    Leonid_Kostin
    Icon for Advocate I rankAdvocate I
    6 years ago

    Hi, amitchandak .

     

    Thank you for your reply!

     

    The formula is: 

    Task Name = RELATED(TT_Tasks[Task Name])
     
    Basically I try to grab a task name from the TT_Tasks to the dataset on the "many" side.
     
     
    Same for Portfolio Name and User Name.
     
    Pretty simple case but still don't understand why after the July update it doesn't work.
     
    Thank you!
  • Leonid_Kostin's avatar
    Leonid_Kostin
    Icon for Advocate I rankAdvocate I
    6 years ago

    Hi again, amitchandak !

     

    I've found one interesting thing...So I checked 2 cases:

     

    1. When I use my own created SQL statement to create a dataset (native query)

    2. When I select the table from "New Source -> SQL Server -> ... " and then make some operations like filtering and ect.

     

    In the first case I have an error during creation of the column using RELATED() function.

    In the second case I don't have any issues.

     

    So the method of loading data is important 🙂modelno errorerror