Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

ns152154185

PBI Dashboard with SAP HANA Schedule Refresh Fails

Submitted by on ‎07-10-2024 12:33 AM

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
See more ideas labeled with:
4 Comments (4 New)
Comments
lbendlin
Super User
Super User
‎07-10-2024 08:59 AM

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

 

Anonymous
Not applicable
‎07-10-2024 07:16 PM

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
Frequent Visitor
‎07-10-2024 11:49 PM

Hi  @Anonymous  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
Super User
‎07-11-2024 03:50 AM

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

Idea Statuses