Forum Discussion

Ankhi's avatar
Ankhi
Frequent Visitor
1 year ago
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.   ...
@Power BI Report Builder
@PowerBI Builder Paginated Report
  • Anonymous's avatar
    Anonymous
    1 year ago

    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:

    Set up the Oracle connection type with SSRS and a Power BI report server - SQL Server Reporting Services (SSRS) | Microsoft Learn

     

    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.

Ankhi's avatar
Ankhi
Frequent Visitor
1 year ago

Thanks for the reply bradsy.. Have gone through the 2nd link..however I am not able to find the option 'Use connection embedded in my report'. when trying to create a data source in the report builder  I just have 3 options in the General section-  Name , Connection Type and Connection String. The connection string build option is greyed out when I choose Oracle as Connection type. 

 

I have followed the steps to install oracle client and set up env variables .. but not able to set up the connectivity via oracle now..

 

Any thoughts?

 

Thanks

Ankhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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:

    Set up the Oracle connection type with SSRS and a Power BI report server - SQL Server Reporting Services (SSRS) | Microsoft Learn

     

    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.

    • Ankhi's avatar
      Ankhi
      Frequent Visitor
      1 year ago

      Thanks Anonymous  I have been able to resolve the issue now