Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have created a report in power bi desktop from Oracle server, now I need to change this data source to SQL Server.
It is possible to change data source Oracle to SQL Server in same .pbix file.
Solved! Go to Solution.
Hi @Anonymous,
I just modified the formula in Advanced Editor for all the queries as Matt mentioned above.
Regards
Hi @Anonymous,
I have created a report in power bi desktop from Oracle server, now I need to change this data source to SQL Server.
It is possible to change data source Oracle to SQL Server in same .pbix file.
Yes, I have tested it on my side, and I can change data source from Oracle to SQL Server in the same .pbix file.
Regards
Can you guide me with the steps for the same
1. Create a new query that points to your Oracle DB.
2. Copy the code (Advanced Editor)
3. Go to your existing query and edit the code in he advanced editor
can you guide me with the steps as to how to do this ?
Hi @Anonymous,
I just modified the formula in Advanced Editor for all the queries as Matt mentioned above.
Regards
This is what I would do (I've never done it)
1. Create a new query that points to your Oracle DB.
2. Copy the code (Advanced Editor)
3. Go to your existing query and edit the code in he advanced editor
you should be able to work out how to replace the old source line with the new one.
Note this assumes that the table you are connecting to is identical in shape and structure.
@Anonymous wrote:
I don't want to go with new query.
I am not saying you need to go with a new query. I am saying start a new query so you can copy the code that is created, then replace the code in the old query with the new code.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |