topic Calculated column failing scheduled refresh on Powerbi.com (Working fine in Power BI Desktop?) in DAX Commands and Tips

Calculated column failing scheduled refresh on Powerbi.com (Working fine in Power BI Desktop?)

Anonymous — Wed, 18 Nov 2020 08:53:41 GMT

Hi,

I have an issue with one of my reports and dashboards published on powerbi.com.

This report and its dashboard is linked to datasets from Sharepoint Folder, OData Feed and Azure Table Storage, and scheduled for refresh every day. For some reason, one of the caluclated columuns that simply calculates amount x price = sales value fails after every refresh. The refresh itself does not give any errors. The follow error message appears in the visual were the calculated column is used:

"The query referenced calculated column 'fact_Ordre_Increase'[Amount x price] which does not hold any data because evaluation of one of the rows caused an error.".

What makes this odd, is that if I do a manual refresh in Power BI Desktop from the same data sources, everything works fine.

When I try re-publish the same updated report to PowerBI.com, the same report and dashboard in PowerBI.com works fine again. The next day, after the scheduled is refresh is finished, it crashes again due to the same calculated column error.

How is this possible, when this calculated column gives no error after refreshing in Power BI Desktop?

Re: Calculated column failing scheduled refresh on Powerbi.com (Working fine in Power BI Desktop?)

Anonymous — Wed, 18 Nov 2020 09:05:18 GMT

I did just discover one mistake I made, and this was that the amount column was formated as text, while the price column was formatted as decimal number. Power BI Desktop seemed to figure this out, giving out a decimal number for the amount x price calculated column. Can this be the reason why the calculated column is failing after auto-updating in PowerBi.com?

Re: Calculated column failing scheduled refresh on Powerbi.com (Working fine in Power BI Desktop?)

amitchandak — Wed, 18 Nov 2020 09:48:02 GMT

Anonymous , Yes this can, it should give some message. You can also change data type in power query or in column tools and check

Re: Calculated column failing scheduled refresh on Powerbi.com (Working fine in Power BI Desktop?)

Anonymous — Wed, 18 Nov 2020 10:35:34 GMT

Thank you for your reply. I tried changing the format and republishing again, but now it gives en error anyways in Powerbi.com. I find it odd that a calculated column can work in Power BI Desktop and not in Powerbi.com, but I managed to use some standard filters for a workaround for the problem.

Re: Calculated column failing scheduled refresh on Powerbi.com (Working fine in Power BI Desktop?)

Anonymous — Tue, 29 Jun 2021 16:21:55 GMT

Hi,
As it's 2021 now and I face the same issue... Is there any SOLVED solution? I googled for 2 days now and could not find any solved solution...
Thank you.

Re: Calculated column failing scheduled refresh on Powerbi.com (Working fine in Power BI Desktop?)

LudvikaLad — Mon, 09 Jan 2023 20:20:03 GMT

Hi,

2023 now, has anyone been able to solve this matter?
amitchandak - have you seen anything alike?