Forum Discussion
Change Connection Oracle to SQL Server
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.
Hi Anonymous,
I just modified the formula in Advanced Editor for all the queries as Matt mentioned above.:smileyhappy:
Regards
10 Replies
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.
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
Hi Anonymous,
I just modified the formula in Advanced Editor for all the queries as Matt mentioned above.:smileyhappy:
Regards
can you guide me with the steps as to how to do this ?
Can you guide me with the steps for the same
