Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!
@amybirc77 Great and thank you for your feedback. Since that solved the problem it was a really misleading error message 😄
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
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!
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |