Calculated column and table is not working on Power BI Service but is working on Power BI Desktop.

[khizar_pbi]

Hi there,

I created a calculated table referencing an existing table in the data model. In my report I used a card visual to display the information from the calculated table, the information is visible on the Power BI Desktop but after I publish it to Power BI Service and refresh the dataset the visual stops working and gives this error.

Working on Desktop:

Not working on Service:

Is this a new issue because previously the visual was working fine on Service too? Any idea why it's happening?

[v-tangjie-msft]

Hi @khizar_pbi ,

Thanks Tutu_in_YYC  and mariussve1  for the quick reply. I have some other thoughts to add:

1. Can you place the calculated column on the card visual object and will it report an error? If it reports an error please provide the error message.
2. Have you encountered this problem before? Was it displaying normally before.
3. As Tutu_in_YYC  mentioned have you tried a scheduled refresh or manual refresh of the semantic model? Check the refresh history to see if the refresh reported any errors.

You can refer to the following documents that may be helpful to you: 

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Calculated table does not refresh after published ... - Microsoft Fabric Community

Using calculated tables in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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

[Tutu_in_YYC]

Can you click See details, and post the information here?

[khizar_pbi]

Here:

[Tutu_in_YYC]

like @mariussve1 mentioned, try refreshing the model. Let us know how it goes

[mariussve1]

Hi,

Just try to run a refresh of the model in service.
If you use XMLA you can only calculate the model or table.