Forum Discussion
Solved
Power Bi Report Builder(Paginated Report)
Hi All, I am trying to create a report in Power BI Report builder whose data set is a output of a procedure. The DB is Oracle. I need to use the output of a stored procedure as my data set. ...
Hi Ankhi ,
follow these steps you may resolve this issue- Open Power BI Report Builder
- In Report Data panel, right-click Data Sources → Add Data Source
- choose connection type as oracle database and paste the connection string here. This will make a connection to oracle database.
- once the data source is created using this datasource create a dataset to fetch data from store procedure which is in oracle db
please gothrough with the below document and screenshot hope it may resolve your Issue:
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You.
Harshitha.
Community Support Team.
Hi Ankhi ,
follow these steps you may resolve this issue
- Open Power BI Report Builder
- In Report Data panel, right-click Data Sources → Add Data Source
- choose connection type as oracle database and paste the connection string here. This will make a connection to oracle database.
- once the data source is created using this datasource create a dataset to fetch data from store procedure which is in oracle db
please gothrough with the below document and screenshot hope it may resolve your Issue:
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You.
Harshitha.
Community Support Team.
Thanks Anonymous I have been able to resolve the issue now