PBI ISSUE

[ChongQian]

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)

[v-yetao1-msft]

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]

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.

[v-yetao1-msft]

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]

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]

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