Forum Discussion
Calculated column and table is not working on Power BI Service but is working on Power BI Desktop.
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?
5 Replies
mariussve1Solution Sage
Hi,
Just try to run a refresh of the model in service.
If you use XMLA you can only calculate the model or table.- Tutu_in_YYC
Super User
Can you click See details, and post the information here?
Here:
- Tutu_in_YYC
like mariussve1 mentioned, try refreshing the model. Let us know how it goes
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.
