Forum Discussion

GuillaumeB_RSM's avatar
GuillaumeB_RSM
Frequent Visitor
2 years ago
Solved

Dataflow refresh error - culture is not supported

Hi all,

 

I have a Power BI Dataflow retrieving data from an API.

Among its table/columns, it is returning date values formatted as english dates. Since last night, the scheduled/On demand refreshs fail because of this error : DataFormat.Error: The specified culture is not supported. <ccon>en-EN</ccon>

 

I haven't made any recent changes to this dataflow. And there is no error showing in the preview/when saving the dataflow (even when using keep errors on all columns), only the refresh fails.

 

I have tried to follow this previous topic : https://community.fabric.microsoft.com/t5/Desktop/Error-The-specified-culture-is-not-supported/m-p/839739

but I can't find the "local setting" on Power VI Service...

 

Can you help me ?

 

Thanks,

 

Guillaume

 

Dataflow
  • JillianHay's avatar
    JillianHay
    2 years ago

    I think I've managed to solve it on my end. I had to go into each dataflow, click options, click regional settings and then pick English (United Kingdom). Save and close, refresh.

7 Replies

  • Banzai's avatar
    Banzai
    Icon for Advocate II rankAdvocate II
    2 years ago

    Same issue here. The PowerPlatform.Dataflows([) Connector fails at the first step:

    • JillianHay's avatar
      JillianHay
      Frequent Visitor
      2 years ago

      I think I've managed to solve it on my end. I had to go into each dataflow, click options, click regional settings and then pick English (United Kingdom). Save and close, refresh.

      • Banzai's avatar
        Banzai
        Icon for Advocate II rankAdvocate II
        2 years ago

        Good grief ðŸ˜« 
        But thanks!

  • JillianHay's avatar
    JillianHay
    Frequent Visitor
    2 years ago

    Same issue. Most of my dataflows are failing since Sunday night (UK time)

  • GuillaumeB_RSM's avatar
    GuillaumeB_RSM
    Frequent Visitor
    2 years ago

    I've found a solution,

    It seems that the "en-EN" culture has been decommissioned for M date functions, so I've switched all my formulas to "en-US" on my dataflow.

    It now refreshes successfully

    • JillianHay's avatar
      JillianHay
      Frequent Visitor
      2 years ago

      Unfortunately, some of my dataflows are failing which don't even contain date fields.....

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Guys GuillaumeB_RSM JillianHay Banzai 

     

    I am facing similar error, when using English (United Arab Emirates) culture in my dataflow. When I am changing it to English (United States) all is working.  Can anyone please confirm if English (United Arab Emirates) culture is decomissioned ? or can we do some settings in Gateway cluster ? or if there is any other solution? 

    I don't want my date format in m/d/yyyy