Issues integrating PBI report builder report with PBI services

Hi All,

I am using PBI report tool to develop paginated reports for the project. I am able to run the report perfectly fine in the developers tool but when I am publishing the same in the PBI services I am getting unpredictable behavior of the reports.

I have oracle on AWS as my datasource the reports.

I tried this with very small data set, writing the SQL query using only one table and having various count of parameters. The position and count of parameter used in the query is giving me unpredictable result set. at times no data and at times error.

Let me know if anyone has faced the similar issue.