Forum Discussion
[Help] Unable to use Incremental Refresh
Hello everyone,
So I just tried to use Incremental Refresh on Power BI. I have tried to set up parameters and filtered the columns needed. I am using ODBC to connect to CDH. However, when I try to do a scheduled refresh, I received this error message:
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The specified culture is not supported."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"en-ID"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 2782255b-ddfa-4340-a5fb-3ca98c30199c
Request ID: 6cedda13-caae-ea8f-7ef1-5d1fde4df66a
Time: 2021-01-30 18:18:09Z
Does anyone know what to do with this piece of information and how can I fix this? Thank you....
- Anonymous5 years ago
It turns out I only need to change the Regional Settings to English (US). I am using date/time parameter to do an incremental refresh
3 Replies
- vanessafvgCommunity Champion
it looks like there might be a data tyepe rror, are your data types matching up at source to power bi? Maybe if you can share a bit more information of what you are trying to refresh from. What are your parameters.
- AnonymousNot applicable
It turns out I only need to change the Regional Settings to English (US). I am using date/time parameter to do an incremental refresh
- AnonymousNot applicable
Hi Anonymous ,
It seems that the date type parameter only can be recognize as "MM/DD/YYYY"(English (US)).
Best Regards,
Jay