Forum Discussion
Value 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 a cube". Please advice, there is not much on this online either.
Thanks
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!
4 Replies
HI amybirc77 ,
I have not seen this kind of error but have you checked these posts? The second one was solved.
Error: The value is not a cube - Microsoft Power BI Community
Solved: Re: Error: 'The value is not a cube', While connec... - Microsoft Power BI Community
SAP BW BEx Value is not a cube - Microsoft Power BI Community
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
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!
hi amybirc77
"Transactions the value is not a cube" -Related blogs below
Solved: Error 'The value is not a cube.' while refreshing ... - Microsoft Power BI Community
Solved: Re: Error: 'The value is not a cube', While connec... - Microsoft Power BI Community
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Seriesamybirc77 Great and thank you for your feedback. Since that solved the problem it was a really misleading error message 😄
