Skip to main content

Hi!

 

We are trying to test the odata service with excel or Power BI to give our customers some buisness data reporting.

 

We have some troubles configurating the odata service, this is reporting us an error when we select visible smart objects and when we access the o data url.

 

This is the error:

 

The culture 'Spanish (Spain)' is not supported.   Pluralization is currently only supported for the English language.

	NotImplementedException: The culture 'Spanish (Spain)' is not supported. Pluralization is currently only supported for the English language.] System.Data.Entity.Design.PluralizationServices.PluralizationService.CreateService(CultureInfo culture) +263321 SmartObjectService.Web.Extensions.StringExtensions..cctor() +23(TypeInitializationException: The type initializer for 'SmartObjectService.Web.Extensions.StringExtensions' threw an exception.] SmartObjectService.Web.Extensions.StringExtensions.Pluralize(String str) +59 SmartObjectService.Web.OData.<>c.<.ctor>b__6_0(SmartObjectFacade a) +40 System.Linq.WhereSelectListIterator`2.MoveNext() +141 System.Linq.Lookup`2.Create(IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer) +183 System.Linq.GroupedEnumerable`3.GetEnumerator() +87 System.Linq.WhereEnumerableIterator`1.MoveNext() +198 System.Linq.<SelectManyIterator>d__16`2.MoveNext() +608 System.Collections.Generic.HashSet`1.UnionWith(IEnumerable`1 other) +107 System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection, IEqualityComparer`1 comparer) +156 SmartObjectService.Web.OData.SmartObjectODataMapper..ctor(IEnumerable`1 smartObjects) +896 SmartObjectService.Web.WebApiConfig.Register(HttpConfiguration config, IDependencyResolver dependencyResolver) +117 SourceCode.Web.Api.Common.DataContexts.K2DataContext.RunAsAppPool(Action action) +47 SmartObjectService.Web.WebApiApplication.Application_Start() +391)HttpException (0x80004005): The type initializer for 'SmartObjectService.Web.Extensions.StringExtensions' threw an exception.] System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +540 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfoo] handlers) +186 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfoo] handlers, IntPtr appContext, HttpContext context) +172 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +402 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +343)HttpException (0x80004005): The type initializer for 'SmartObjectService.Web.Extensions.StringExtensions' threw an exception.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +539 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +125 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +731

 

 

We are running K2 Five (5.0001.1000.1).

 

Thanks in advance.

Hi,


 


Please let us know if you still have issue with configuring odata service in Power BI.


I'm not an expert on this. Issue might be related to Regional Settings in Power BI Destkop's app. Maybe you can check which current local set is being set in report:


1. File > Options and settings > Options.


2. Under Current file, select Regional Settings.


3. In the Locale box


Reply