Value is not a cube error

[amybirc77]

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

[Mikelytics]

@amybirc77 Great and thank you for your feedback. Since that solved the problem it was a really misleading error message 😄

[ribisht17]

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 Series

[Mikelytics]

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.

[amybirc77 · Accepted solution]

@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!