This post explains a tip when you build the paginated report for Power BI Service and Power BI Report Server. Both the version of paginated reports are .rdl files.
Let me start with simple question.
If you have rdl file published in Power BI service and working there, will the same rdl work in Power BI report server?
Almost, all of us will say YES because we know that there is no difference in RDL file on both the version. This blog post explains, there are certain cases the same RDL will not work in Power BI report server.
I have a paginated report with Oracle as a source and it is working fine in Power BI Paginated Report builder and Power BI Service. I have a data parameter with below name and the same is used in the dataset.
:Start & :End – If you use Oracle in report builder, you need to use “:” for parameters.
The same rdl with Oracle is not working and it ended up with below error in web portal.
Error – An error has occurred during report processing (rsProcessingAborted). Query execution failed for dataset XXXX (rsErrorExecutingCommand).
It shows that there is an error in the dataset. To investigate further, we need to use Microsoft Report Builder (Optimized version of Power BI Report Server / SSRS).
I started to run the query in Dataset – Query Designer and I got the below error.
Error – An error occurred while executing the query. ORA-01745: Invalid host/bind variable name.
The above error conveys something that there is an issue with the parameter / variable which we defined. I have renamed the parameter as :StartDate and :EndDate and it worked.
Published the updated RDL in report server and it worked there also without an issue.