Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

[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....

  • Anonymous's avatar
    Anonymous
    5 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

  • vanessafvg's avatar
    vanessafvg
    Community 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.

    • Anonymous's avatar
      Anonymous
      Not 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    It seems that the date type parameter only can be recognize as "MM/DD/YYYY"(English (US)).

     

    Best Regards,

    Jay