Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Could not load data for the Visual in Power BI Service

In Power BI Service visual for one of my calculated column is not getting loaded. It is giving the following error: "The query referenced calculated column 'RequestCountPerUser'[HourTime] which does...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

In my case i had a calculated column, that was breaking the refresh of report in PB service.

I delete the calculated column and that fixed the problem.

 

Hope it help in your case!

Piotrrekk's avatar
Piotrrekk
Frequent Visitor
3 years ago

Hi Jrubio93,
I guess your solution would work for me, but the calculated column is actually required.
Were you able to find a way to create calculated column?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    i just imported that column, instead of creating a copy ' calculated column'. 
    Could it work for you creating a Dax or a measure?

    • Piotrrekk's avatar
      Piotrrekk
      Frequent Visitor
      3 years ago

      hi Jrubio93,
      The interesting fact is that I'm able to create measure and it's not resulting with error. Unfortunately it's not possible to use Measure in X or Y axis, so still column is required. Another issue is that I'm not able to create column on query editor as I don't have access to source data:( Issue remain open for me 😞