Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cyclic reference error

I found, so I though, a solution to a timesheet problem (to display timesheets with no data), but it uses "M code", something I'm totally unfamiliar with.  I duly imported the code and, after several...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    AFAIK, the second parameter of 'Table.SelectColumns' function is a list of string values.  But the parameter which you provide seems like inputted a list with multiple list values in it.

     

    Maybe you can try to use following formula to replace original one or add list index to return specific row from that list.

    Get_core_fields = Table.SelectColumns(Filter_for_Work_Resources_who_are_Users,{"ResourceId", "ResourceCreatedDate", "ResourceEmailAddress", "ResourceName", "TeamName", "ResourceDepartments"})
    Get_core_fields = Table.SelectColumns(Filter_for_Work_Resources_who_are_Users,{Resources[ResourceId]{0}, Resources[ResourceCreatedDate]{0}, Resources[ResourceEmailAddress]{0}, Resources[ResourceName]{0}, Resources[TeamName]{0}, Resources[ResourceDepartments]{0}})

    BTW, can you please provide more info about 'resource'? I'm not so clear for it.


    If it is reference from current query table, you will faced cycle reference issue when you use the reference query table to calculate with current query table.

     

    Regards,

    Xiaoxin Sheng

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

Have you tried to clear your cache in Options? Also, do you know at which step the error was produced?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    Ummmm, I've been using Power BI for a whole 2 months, starting from nothing with no training apart from what I can find on message boards and the Community site.

     

    How would I clear the cache ?

     

    As to where, the error occurs, I've entered the formula, it says there are no syntax errors, so I click Done and it then tells me that there's a cyclic reference error, and displays the following code

     

    = Table.SelectColumns(Filter_for_Work_Resources_who_are_Users,({Resources[ResourceId], Resources[ResourceCreatedDate], Resources[ResourceEmailAddress], Resources[ResourceName], Resources[TeamName], Resources[ResourceDepartments]}))

     

    Thanks though for the cache hint, and, if I can find what to do, I'll try it.

     

    Rgds

    Fred

    • SJim's avatar
      SJim
      Frequent Visitor
      7 years ago

      To clear the cache in Power BI Desktop:  File > Options and Settings > Options > Data Load > Clear Cache

       

      Regards, 

      Jim

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi SJim

         

        Thanks for that, got it and done it.  Useful for future reference

         

        Regards

        Fred