Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

PBI ISSUE

Unexpected error: [Expression.Error] The value is not a cube.
Details:
Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] The value is not a cube.
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

Status: Investigating

Hi  @ChongQian 

1. Confirm how many data sources this report has? Make sure you have permissions to all data sources.
2. Confirm that your version of Desktop is the same as your version of IT? Different versions of Desktop can sometimes cause errors.

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi  @ChongQian 

Can you provide more information for reference ?  For example , when did this problem occur? What are you doing when this issue arises? Have you encountered a similar error before?  I've found some similar posts that you can refer to for their solutions.

Solved: Re: Error: 'The value is not a cube', While connec... - Microsoft Fabric Community

Solved: Value is not a cube error - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

ChongQian
New Member

Hi @v-yetao1-msft ,

 

Thanks for your reply.

 

This error may seem related to database, But our IT confirms that it has granted me permission to database. Our IT colleagues have no problem opening this PBI file Only if I open this file will I prompt for this error, Below is a screenshot, please help in looking at what is the reason, how to solve the problem, Appreciate you in advance.

 

 

PBI Iuuse.png

v-yetao1-msft
Community Support

Hi  @ChongQian 

Did you add this action of appended query1 yourself? What is this column data type that you append? Is it the same as the append data type?

 

Best Regards,
Community Support Team _ Ailsa Tao

ChongQian
New Member

Hi @v-yetao1-msft 

 

I did not add any query action....

 

Actually, I opened PBI File like this, this report was not created by me, it was recently transferred to me to manage, but as it stands, even viewing the data is a problem.

 

 

v-yetao1-msft
Community Support
Status changed to: Investigating

Hi  @ChongQian 

1. Confirm how many data sources this report has? Make sure you have permissions to all data sources.
2. Confirm that your version of Desktop is the same as your version of IT? Different versions of Desktop can sometimes cause errors.

 

Best Regards,
Community Support Team _ Ailsa Tao