Forum Discussion

mueland's avatar
mueland
Frequent Visitor
9 years ago
Solved

Error Power Bi Service refresh dataset

Hi,   Really appreciate som help here!   I have built a report in Power BI desktop. Everything works on my laptop and when I publish the report looks nice and all visuals are working. However, wh...
Need Help
  • mueland's avatar
    mueland
    9 years ago

    Hi v-ljerr-msft

     

    Thank you very much! 

     

    In my case it wasn't a case of date format but will explore if that could have been the case.

     

    My "columnx" was a calculated column that was based on another "columnY". "ColumnY" was used the funciotn RELATED, getting values from an other table. Instead of using RELATED i merged the other table in the query and then it worked with the update in the Power Bi Service, as well as on the desktop version. Not sure why but it worked.

     

     

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi mueland,

 

Based on my research, this issue usually occurs when a Date calculate column is used in a visual. Followings are two similar threads in which two solutions are mentioned. Could you go to check if it helps?:smileyhappy:

 

1. Use Format: http://community.powerbi.com/t5/Desktop/On-calculated-field-using-the-date-hierarchy-causes-an-error/m-p/37855

2. Remove all the dates earlier than 1900-01-01:  http://community.powerbi.com/t5/Desktop/Date-Hierarchy-couldn-t-load-the-data-for-this-visual/m-p/63257

 

Regards