Report error in WEB view. No error in Power BI desktop

[marciorosalen]

Dear advanced users, I ask for help, please.

Error in Web page:

The query referenced calculated column '<oii>Histórico Operação</oii>'[<oii>SepMinutosPorCarga</oii>] which does not hold any data because evaluation of one of the rows caused an error.

No error in Power BI desktop. No error in data base. 

Thanks

[Anonymous]

Hi @marciorosalen ,

It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[Anonymous]

Hi @marciorosalen,
This can happen, from past experience, because of data type mismatches, especially with date type columns, you can check that the values in your calculated columns are matching each other, you can also use Column quality checks in power query to see where the missing values are coming from and how to avoid them.
Here are the cases I have found for you that have been resolved, hope this helps!
Solved: Re: Service: "Couldn't load the data for this visu... - Page 2 - Microsoft Fabric Community
Solved: Re: Couldn't load the data for this visual (calcul... - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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