cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mb0307
Post Patron
Post Patron

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.

1 ACCEPTED SOLUTION
mahoneypat
Super User IV
Super User IV

I'm guessing it is related to the day going to two digits (10) and your step where it adds "0" to it.  Your last step should address that, but here is a simpler way to get to your desired format with Date.ToText.

 

let

Minus6MonthsFirstDayOfMonth = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.FixedLocalNow()),-6)),
Custom1 = Date.ToText(Minus6MonthsFirstDayOfMonth, "MM/dd/yyyy")
in
Custom1

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Super User IV
Super User IV

I'm guessing it is related to the day going to two digits (10) and your step where it adds "0" to it.  Your last step should address that, but here is a simpler way to get to your desired format with Date.ToText.

 

let

Minus6MonthsFirstDayOfMonth = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.FixedLocalNow()),-6)),
Custom1 = Date.ToText(Minus6MonthsFirstDayOfMonth, "MM/dd/yyyy")
in
Custom1

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

@mahoneypat  Thanks that worked. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors