Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
But still no success.
Help will be much appreciated.
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.