Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

PBI Dashboard with SAP HANA Schedule Refresh Fails

Hi @lbendlin,

I am getting this schedule refresh fail issue from past many months and I am not able to figure out the problem.
Any suggestion that would solve the problem would be appreciated.

Screenshot 2024-07-09 223543.png

Status: Needs Info

Hi @ns152154185 

Can you refresh normally in Power BI Desktop ? According to the error message, there is a problem converting the data type from NVARCHAR to UCS2, you can check the corresponding data to see if the problem exists.

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
lbendlin
Super User

Looks like you have a special character that cannot be properly converted to UTF-16 LE

 

v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @ns152154185 

Can you refresh normally in Power BI Desktop ? According to the error message, there is a problem converting the data type from NVARCHAR to UCS2, you can check the corresponding data to see if the problem exists.

 

Best Regards,
Community Support Team _ Ailsa Tao

ns152154185
New Member

Hi  @v-yetao1-msft  and @lbendlin 

Thanks for your response.
Yeah I can refresh normally in Power BI Desktop and also in service it is scheduled to refresh 9 times a day out of which it fails 3-4 times a day.
If there was a special character then it might be failing every time as it should not be able to convert in next refresh also? Does make that sense?

Best Regards

lbendlin
Super User

Random failures are often caused by gateway cluster members not being configured exactly the same.