Forum Discussion

lojith's avatar
lojith
Frequent Visitor
1 year ago
Solved

Pass Oracle Server Name from flat file to Power BI

Hi - I am connecting Power BI to Oracle DB. I would like to pass the DB name from flat file to Power BO so that users can change the server name in flat file and run in different Oracle servers witho...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    1 year ago

    You can achieve that using parameters. In Power BI, go to Home > Get Data > Text/CSV.

     

    • Select your file (DB_Parameter.txt) and load it into Power BI.
    • This will import the file content as a single-column table.

    Then :

     

    • In Transform Data, go to Manage Parameters > New Parameter.
    • Name the parameter ServerName.
    • Set the Type to Text.
    • Under Current Value, use Data Source Settings to dynamically reference the column with the server name by selecting the column name from the DB_Parameter.txt file.

     

    Then go back to Home tab, go to Get Data > Oracle Database.

    When setting up the connection, instead of entering the server name directly, enter the parameter you just created.

     

     

     

     

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi lojith ,

     

    Please convert the single column table to a list.

     

    Best Regards,

    Wearsky

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
1 year ago

Have you try converting the column to a list ?

lojith's avatar
lojith
Frequent Visitor
1 year ago

Sorry for the late reply as I was Out of Office. Yes, I tried converting to list and was able to select the parameter file. But the next problem is it is expecting to provide a current value. I have provided a Server Name.

 

In the parameter flat fle, I have given a different server name. But the parameter is not taking the new value, it still uses the initial value given in Current Value. Is there a way to update the Current value with the value provided in the flat file?