Forum Discussion
Solved
Importing Data from Oracle Database via advanced editor results in Date offset
I have a specific query built and stored in Oracle as a view: SELECT
TEAM_ASSIGNED
, REPORT_YEAR
, REPORT_MONTH
, REPORT_MONTH_NUM
, REPORT_DAY
, REPORT_DAY_NUM
, REPORT_DATE
, REPORT_PERIOD...
So work around is to remove all references to TO_CHAR([DATE],'D') and instead use TO_CHAR([DATE],'DY') I can only assume this is because the Power BI servers start their weeks on Sunday instead of Monday, and therefore all Day numbers start one day sooner. Fortunately, the Day names stay the same, so you can use the DY function to look for MON to start your week.
So work around is to remove all references to TO_CHAR([DATE],'D') and instead use TO_CHAR([DATE],'DY') I can only assume this is because the Power BI servers start their weeks on Sunday instead of Monday, and therefore all Day numbers start one day sooner. Fortunately, the Day names stay the same, so you can use the DY function to look for MON to start your week.