cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
GuillaumeB_RSM
Frequent Visitor

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/8...

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

 

Can you help me ?

 

Thanks,

 

Guillaume

 

1 ACCEPTED SOLUTION

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.

View solution in original post

6 REPLIES 6
Banzai
Advocate I
Advocate I

Same issue here. The PowerPlatform.Dataflows([) Connector fails at the first step:
Screenshot 2023-10-09 at 11.12.36.png

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.

Good grief 😫 
But thanks!

GuillaumeB_RSM
Frequent Visitor

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

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

JillianHay
Frequent Visitor

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors