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

Here, HourTime is the calculated column that basically calculate the Time from the TimeStamp column.

Note: The visual works in Power Bi desktop when Model is refreshed. The issue is pertinent only to the Power BI Service. Even in Power Bi Service the Visual works when the Model is published, the issue appears when the Model is refreshed.

Thanks!

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

     

    Hi,

    Did you find a solution to this? I am also getting the same error

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      No I didn't find the solution but I resolved the issue by creating a table with single column named HourTime and creating relationships among other tables.
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous 

         

        Thanks for the reply.

         

        I resolved the issue by adding tha same calculated column in the query level

         

        Regards,

        Maddy

         

         

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi Anonymous,

     

    I have had a test based on your scenario, but I cannot reproduce your issue.

     

    What data source do you connect?

     

    Have you changed something before refreshed? 

     

    In addition, maybe this is a temporary issue, please refresh your browser and load again.

     

    If you still have this issue, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best Regards,

    Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Getting same error over here too. Any idea how to fix it?

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