Forum Discussion
Refreshing on PBI Service creates a problem with a relationship
The process I have just undergone is : 1. Create a .pbix on desktop that is connected to a SharePoint folder. 2. Test the refresh on desktop (success) 3. Upload .pbix to PBI service 4. Test ...
It is a data type or formatting mismatch in your column. There is a similar thread here : https://community.powerbi.com/t5/Desktop/On-calculated-field-using-the-date-hierarchy-causes-an-error/td-p/37824
Thanks but i have not been able to solve the problem with anything in that link.
One key difference is that mine works fine on Desktop, its only when uploaded onto Service and refreshed that the problem occurs.
I can even download the file again, after the errors show up on Service, and the same file works fine on Desktop.