- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The specified culture is not supported
I'm doing similar operations to the case reported here - https://community.powerbi.com/t5/Service/Specified-culture-is-not-supported-error/td-p/8730 - but the solution there is not working for me currently.
Dates = {List.Distinct(SupportAllCases[CaseCreatedDate]),List.Distinct(SupportAllCases[CaseClosedDate])},
#"Converted to Table" = Table.FromList(Dates, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandListColumn(#"Converted to Table", "Column1"),
#"Removed Duplicates" = Table.Distinct(#"Expanded Column1"),
#"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"Column1", "Dates"}}),
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Renamed Columns", {{"Dates", type date}}, "en-150")
in
#"Changed Type with Locale"
2.56.5023.1021 (PBIDesktop) (x64)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Mogura27,
I have made a test with the information you provide by entering data and edit in Editor Queries, publish the report to Power BI Service and have a refresh, everything works well.
For another way, I configured an on-premises gateway and refresh the dataset, it also refresh successfully without any error.
Do you have this error when you configure a gateway? If it is, could you share more details of the error?
Could you share a dummy pbix file which can reproduce this issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Here is a sanitized test that repro's the problem.
https://www.dropbox.com/sh/vnc06qs9p6ku4cn/AAAwobNwCIyj0tCIBLCkdytga?dl=0
The source dataset is a JSON file, with a subset of actual data from the production system as returned by the provider system and intermediary proxy. The date column strings are in dd/mm/yyyy format.
The pbix will initially publish this dataset correctly without errors, but a refresh with a gateway configured for the JSON file will throw the error. Removing the Changed Type with Locale steps from the 'locale-bug' table will let the dataset refresh online correctly.
- Locale-bug (source) and Query2 (target) both have Changed Type with Locale = Failure
- Only Query2 (target) has Changed Type with Locale = Success
- Only Locale-bug (source) has Changed Type with Locale = Failure
I need to be able to do date-based analysis of the rows in the primary table. I do control the source for the intermediary proxy, so I can transform the date strings from dd/mm/yyyy to mm/dd/yyyy to make it PBI friendly, but I would prefer to not to have to do that, and just use the pass-through data as-is without any mid-stream modification.
For reference, I have the following columns in the primary table from the provider:
- Created date/time
- Closed date/time
- First activity date/time
I need to do filters and aggregation on those values, and derive additional values of the difference of (3 - 1) and (2 - 1). I could potentially derive the string columns from the source table, convert the types in derived tables, then link them back in a relationship on the row's primary unique ID. That's messy as well, which makes risks of problems.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
After I originally made this post, it disappeared for me for some reason, so there's a duplicate post at https://community.powerbi.com/t5/Service/The-specified-culture-is-not-supported-on-an-extracted-date..., and an issue report at https://community.powerbi.com/t5/Issues/App-Dataset-refresh-fails-with-a-table-derived-from-a-date/i...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
09-01-2021 02:27 AM | |||
09-25-2024 03:21 AM | |||
10-23-2015 03:39 AM | |||
02-26-2021 02:22 AM | |||
10-03-2023 05:32 AM |
User | Count |
---|---|
25 | |
17 | |
10 | |
10 | |
9 |
User | Count |
---|---|
35 | |
25 | |
19 | |
14 | |
13 |