Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 without having to manually change in Pbix file.
Could anyone guide me on how to achieve this? Tried to use Query but did not work out.
Instead of Server Name, it should be able to pass Server_Name from say "C:\Users\User1\DB_Parameter.txt"
Solved! Go to Solution.
You can achieve that using parameters. In Power BI, go to Home > Get Data > Text/CSV.
Then :
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.
You can achieve that using parameters. In Power BI, go to Home > Get Data > Text/CSV.
Then :
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.
Thanks @AmiraBedh for your response. I have followed the steps you have mentioned. Imported the file. In the New Parameter window, unable to reference the column from the imported table. The Query option is coming as disabled. How can I dynamicallly reference the Servername vlaue nder Current Value? Am i missing something? Thanks.
Have you try converting the column to a list ?
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |