Issue with HANA Studio and Power BI Service

[MaartenZ]

Hi,

I have created a Calculation View in HANA Studio and I have built a Power BI report on top of that. When previewing the data in the View and in Power BI desktop everything works and looks good. However, in the Power BI Service 1 fields gives me errors and doesn't allow me to see the visual. This is the error message:

Activity ID: 9964aa9d-0d58-4931-90f1-74ec65c46479
Request ID: ed68c6bf-0680-41e8-86c0-97618f50ee1a
Correlation ID: 20249dbf-a434-39bb-9814-0782a281d9fd
Time: Wed Oct 05 2022 14:17:15 GMT+0200 (Central European Summer Time)
Service version: 13.0.19183.51
Client version: 2209.4.13431-train
Cluster URI: https://e5f498be730345fda5949e3fd22a77d7-api.analysis.windows.net/

It is the ERUHR field from VEKP which I have created a Calculated Column for with nothing more than Datatype TIME and expression "ERUHR". So, I have not changed anything except the data type. Is there a solution for this problem as I don't seem to find any?

[v-yetao1-msft]

Hi @MaartenZ 

What is the type pf the field ? If you delete the calculated column and then republish the report to Service , can you see the visual successfully ? Can you provide the formula for me ?

Best Regards,
Community Support Team _ Ailsa Tao

[MaartenZ]

Hi @v-yetao1-msft,

If I remove the calculated column I will indeed see the visual succesfully, so I know for sure it is the ERUHR field that is causing issues. This is the formule if you can even call it a formula. Normally the ERUHR is a VARCHAR I think, so it will show the data as 085706 for example instead of 08:57:06 which is easier to read.

This is the error as in Power BI Service:

And in the Desktop it looks like this: