Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
5 years ago
Solved

DataSource.Error - enter value in a permitted format'

Hi,

 

START DATE query below is being used as parameter to filter the data extracted from SAP BW.

 

let
    Today = Date.From(DateTime.FixedLocalNow()),

    Minus6MonthsFirstDayOfMonth = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.FixedLocalNow()),-6)),
    Year6Months = Text.From(Date.Year(Minus6MonthsFirstDayOfMonth)),
    Month6Months = "0"&Text.From(Date.Month(Minus6MonthsFirstDayOfMonth)),
    Day6Months = "0"&Text.From(Date.Day(Minus6MonthsFirstDayOfMonth)),
    CreateTextForQueryStart = Text.End(Day6Months,2) &"/"& Text.End(Month6Months,2) &"/"& Year6Months

in
    CreateTextForQueryStart

 

 

 

and in the main SAP extraction query, START DATE parameter is being used like this:

 

 {Cube.ApplyParameter, "[!V000018]", {#"Start Date", #"End Date"}},

 

 

It was all working fine but since this morning it started to throw this error:

 

DataSource.Error: The SAP BW server reported an error: 'For characteristic 0DSDEL_DATE, enter value in a permitted format'. To find more information about this error, visit the SAP support site and search for 'BRAIN 599'.
Details:
    DataSourceKind=SapBusinessWarehouse
    DataSourcePath=usa-bw4-01/00/100
    ID=BRAIN
    NUMBER=599
    MESSAGE_V1=0DSDEL_DATE
    MESSAGE_V2=15/01/2021
    SYSTEM=BLPCLNT100
    Command=SELECT
    {
        [Measures].[00O2TNTRG745UYK7Z5GU1UJ8N],
        [Measures].[00O2TNTRG745RUP66ISOKJ0HI],
        [Measures].[00O2TNTRG747L8XHPR7RCH5TX],
        [Measures].[00O2TNTRG745RUP66ISOKIHIU]
    }ON 0,
    NON EMPTY CROSSJOIN(
        CROSSJOIN(
            CROSSJOIN(
                CROSSJOIN(
                    CROSSJOIN(
                        CROSSJOIN(
             
                                                     ...

 

 

I tried following:

  • Change START DATE format to US and UK - no success
  • My computer regional setting set to UK
  • Power BI regional setting set to UK
  • SAP user profile setting set to UK

But still no success.

 

Help will be much appreciated.