Forum Discussion
Strange error message with calculation item
I ended up discovering the cause of this and so thought I would post it in case someone else comes across this error.
The calculation item in the error referenced a measure which had stopped working because a column data type had changed. Seems simple but there were quite a few measures in the calculation item and it took a while to find the broken one. Also the error message seemed to me to point to a different issue. Not sure how it was working for me and not another user when one of the measures referenced was broken and a column data type was changed.
Cheers
tenfingers , One is clear cache and try.
2. How is this connected. You have updated the crendential in power bi service or it is using gateway.
See like some security on a object is issue. Not very clear on that
Thanks amitchandak
The issue resolved by itself. Not connected through a gateway , source is OData and credentials correct. I think you may be right on the cache as it was fixed for me but persisted for a different user. Thanks for replying 😊