cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with HANA Studio and Power BI Service

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?

Status: Needs Info

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

Comments
Ailsa-msft
Community Support
Status changed to: Needs Info

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
New Member

Hi @Ailsa-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.

MaartenZ_0-1665039423718.png

 

This is the error as in Power BI Service:

MaartenZ_1-1665039548538.png

 

And in the Desktop it looks like this:

MaartenZ_2-1665039722973.png