Forum Discussion

LuZeta_39's avatar
LuZeta_39
Frequent Visitor
4 years ago
Solved

Couldn't load the data for this visual

Hi, I can't see my visual in the Workspace but I can see it in PowerBI desktop I get the following error: " The query referenced calculated column '07-AUX Org Chart Proyectos'[Liderazgos] which d...
Need Help
  • LuZeta_39's avatar
    LuZeta_39
    4 years ago

    Problem solved. I created another table that was " Table = PowerBI Dataset " and referenced the formulas to that table. 

    Must be a problem o PowerBI Dataset integration in Workspaces.

     

    Thank you all.

lbendlin's avatar
lbendlin
Super User
4 years ago

This part 

FILTER('02-DB Liderazgo',SEARCH('07-AUX Org Chart Proyectos'[Search Field],'02-DB Liderazgo'[CREADOR],,0))

is missing a comparator value. SEARCH returns a number, not True/False and not a filter context.

  • LuZeta_39's avatar
    LuZeta_39
    Frequent Visitor
    4 years ago

    Thank you,

    I made some adjustsments:

     

    IF(CALCULATE(COUNTROWS('02-DB Liderazgo'),FILTER('02-DB Liderazgo',CONTAINSSTRING('02-DB Liderazgo'[CREADOR],'07-AUX Org Chart Proyectos'[Search Field])),FILTER('02-DB Liderazgo','02-DB Liderazgo'[DEPARTAMENTO]="Proyectos"))=BLANK(),0,CALCULATE(COUNTROWS('02-DB Liderazgo'),FILTER('02-DB Liderazgo',CONTAINSSTRING('02-DB Liderazgo'[CREADOR],'07-AUX Org Chart Proyectos'[Search Field])),FILTER('02-DB Liderazgo','02-DB Liderazgo'[DEPARTAMENTO]="Proyectos")))

     

    Still the visual shows me the data in Desktop mode but can't display the visual in the workspace. 

    The query referenced calculated column '07-AUX Org Chart Proyectos'[Liderazgos] which does not hold any data because evaluation of one of the rows caused an error.