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 does not hold any data because evaluation of one of the rows caused an error.

  • Activity ID61d9a4ca-02cd-440a-8c7f-a8be5b892190
  • Request ID6b5cb628-a8fb-41f7-9e31-ea7ba2db234c
  • Correlation ID61b9aa0b-bcf4-d28e-879b-2fc8b3ead5a3
  • TimeSat Dec 25 2021 14:05:32 GMT-0300 (hora estándar de Argentina)
  • Service version13.0.17333.39
  • Client version2112.2.09063-train
  • Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net/

"

The calculated column has this formula (I tried to avoid null values or errors with no luck):

"Liderazgos = IF(
ISBLANK(IFERROR(CALCULATE(COUNTROWS('02-DB Liderazgo'),FILTER('02-DB Liderazgo',SEARCH('07-AUX Org Chart Proyectos'[Search Field],'02-DB Liderazgo'[CREADOR],,0)),FILTER('02-DB Liderazgo','02-DB Liderazgo'[DEPARTAMENTO]="Proyectos")),0))=TRUE(),
0,
IFERROR(CALCULATE(COUNTROWS('02-DB Liderazgo'),FILTER('02-DB Liderazgo',SEARCH('07-AUX Org Chart Proyectos'[Search Field],'02-DB Liderazgo'[CREADOR],,0)),FILTER('02-DB Liderazgo','02-DB Liderazgo'[DEPARTAMENTO]="Proyectos"),FILTER('02-DB Liderazgo','02-DB Liderazgo'[DEPARTAMENTO]="Proyectos")),0))
"
The formula in bold is the basic calculation I want to do.
 
  1. '02-DB Liderazgo' is a PowerBI Dataset, I checked permissions but they are ok. The others visuals uses this Database and they are working just fine. 
  2. This is the only calculated column used in this page.
  3. I checked my column data type and tried changing from whole number to text with no success.
 
Any help is appreciated. 
Thank you.
 
 
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.

3 Replies

  • 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.

  • LuZeta_39's avatar
    LuZeta_39
    Frequent Visitor
    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.