Forum Discussion

jmateo's avatar
jmateo
New Member
3 years ago

Error with Microsoft Power BI template | Hybrid Workforce Experience

Hey everyone,

 

I'm attempting to use a Microsoft-available Power BI template (Hybrid Workforce Experience) and receiving the following error:

 

Couldn't load the data for this visual

The query referenced calculated the table '%workload' which does not hold any data because there is an error in its expression.

 

When I click on the Workmode field, it states the following error:

 

This expression refers to a Partition object named '% workmode[%workmode-23288595-2f05-4f34-ac7b-c0033296396b]', which has an error.

 

Any ideas on what I could have done wrong? I followed the instructions Microsoft provided and because it's a template they made available for Viva Insights users, I trust the template itself is correct.

Need Help

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, jmateo ;

    Can you check if each step in Power query is correct? According to the error message, it should be an expression error.

    If the above one can't help you get the desired result, It is better if you can share a simplified pbix file or more details. You can refer the following link to upload the file to the community. Thank you.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jmateo's avatar
      jmateo
      New Member
      3 years ago

      Thanks for the reply! We ultimately found the two issues:

      1. The Hybrid Manual table / worksetting attribute came in as text instead of as an integer so we had to transform it
      2. We originally imported data without having the Organization attribute (which is a requirement)

      We were able to publish the dashboard. Now in the middle of validating it to confirm there aren't any other issues.