Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anyone know what this error means?

I have a mixed mode dataset that this column works perfectly fine on....no issues at all.  

 

However, when I connect to this dataset (desktop) to create a report, that same column does not work...and I get this message.   I am connect via Live Connection to this mixed mode dataset.    The column is below.  The RMAItems table is an imported dataflow, the SLItem table is a direct query table.  

 

RMA Item to Return Unit Cost =
LOOKUPVALUE (
SLItemwhses_Query[CurUCost],
SLItemwhses_Query[Item], RMAItems_Query[RMA Item To Return],0
)

 

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Hard to say without seeing your setup.  Two comments

     

    1. Try to rewrite your calculated column differently. Use the data model and the RELATED() function. I had lots of problems with LOOKUPVALUE and mixed models.

    2. If you have a Pro license then you may want to raise a Pro ticket at support.powerbi.com - they can check the Azure logs and maybe provide a better explanation.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

    In Power BI desktop, please check the calculated column RMAItems_Query[RMA Repliacement Item Unit Cost] and other DAXs that reference this column for any errors.

    Are there NULL or Blank in the referenced MAItems_Query[RMA Repliacement Item Unit Cost] column?

     

    You can try the following solutions:

    Create a single-column table named RMAItems_Query[RMA Repliacement Item Unit Cost] and create relationships between other tables.

     

    This is a link to related content, hope it will help you:

    https://community.powerbi.com/t5/Service/Could-not-load-data-for-the-Visual-in-Power-BI-Service/td-p/447191

     

    Best Regards,

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.