Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI Report Builder Error

I have a report which I've transitioned to Power BI Report Builder from Report Builder 3.0. I've set everything up the same as it was on Report Builder 3.0 with the exclusion of a dsDefaultDates data...
report builder
report builder parameter
Report Data Set
AbhiSSRS's avatar
AbhiSSRS
Solution Sage
5 years ago

To look at these errors I usually deploy/upload the report to a local PBIRS instance and then run it. The PBIRS

locally logs it in PBIRS logs in detail and I am able to see the actual issue there.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

When I published to my PBIRS, I received this error when it tried to load. A much more clear error of what's going on. 

 

Within my query to get new accounts (which hits my Oracle DB), it is this part which ties back in to the dsDefaultDate dataset which adds the Start and Stop date parameters:

 

A.CONTRACTDATE >= :pStartDate AND
A.CONTRACTDATE < :pStopDate

 

I also altered my dsDefaultDates query to the below to give me the newest of accounts as of the previous day to the same time last year. It runs in Oracle Developer but the date format is different.

 

select
trunc(trunc(sysdate,'DD')-366, 'DD') StartDate,
trunc(sysdate, 'DD')-1 StopDate
from dual;

 

 

When I had the first page loaded initially in PBI Report Builder (before I try to go to the next page and receive the initial error), the dates look to be in a correct format for Oracle.