Forum Discussion
amybirc77
Helper II
Helper IIValue is not a cube error
Hi All, In my PBI , I connected and imported data, few measures and a date, everything is fine, but when I had to add another date filed, it is throwing me the error "Transactions the value is not...
ribisht17 Mikelytics Thanks for your time and for the links. The links are helpful, but did not resolve my issue. I was wondering when I did not face issue adding the first date field, how did I get the error when adding the second one. I opened the SSAS CUBE and compared both the date dimensions, one of the attribute which us a DATE field was coming in as TEXT, I changed it to DATE and reprocessed the cube, refreshed the query editor and the error is gone.
Thanks a lot!
Mikelytics
Resident Rockstar
Resident Rockstaramybirc77 Great and thank you for your feedback. Since that solved the problem it was a really misleading error message 😄