Forum Discussion

DeBIe's avatar
DeBIe
Icon for Post Partisan rankPost Partisan
5 years ago

Fixed problem "An Error occured while rendering the report"

Hi All,

 

I encountered this problem/error and I've solved it for myself. I've seen more people struggle with the problem. I was not sure where to share my experience with this problem, excuse me if I posted it in the wrong section. 

 

I was working on a report and I was creating a dimension table. I pulled in a few date fields from another table which was working fine. After that, I tried to pull in another date field and that's when the error came up. It only happened when I pulled in that specific date field. The table I was getting the data from had two columns: Date and Date&Time. I tried pulling in both columns instead of one and that's when it worked. I didn't get the error anymore. I think something went wrong with automatic date hierarchy detection from PBI?

 

Hope this helps to others.

Show and Tell

3 Replies

    • DeBIe's avatar
      DeBIe
      Icon for Post Partisan rankPost Partisan
      5 years ago

      amitchandak 

      Is this what you mean?

       

      Feedback Type:
      Frown (Error)

      Timestamp:
      2020-11-06T13:53:07.5841921Z

      Local Time:
      2020-11-06T14:53:07.5841921+01:00

      Session ID:
      cf24b863-9a94-4ada-8294-0e038bb3b670

      Release:
      October 2020

      Product Version:
      2.86.902.0 (20.10) (x64)

       




  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, DeBIe 

     

    It’s my pleasure to answer for you.

    According to your description,It’s not clear why this problem occurred, but it’s not like a program problem.Could you mind providing your practice and some sample data to explain your behavior in detail?Errors between data types and table relationships may also cause problems.You can check if the latest version of desktop is installed.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Related content