Change Connection Oracle to SQL Server

[Anonymous]

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. 

[v-ljerr-msft]

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

[AnkushSahajpal]

Can you guide me with the steps for the same 

[Anonymous]

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

[AnkushSahajpal]

can you guide me with the steps as to how to do this ?

[Anonymous]

Can you tell me the steps.

[v-ljerr-msft · Accepted solution]

 Hi @Anonymous,

I just modified the formula in Advanced Editor for all the queries as Matt mentioned above.

Regards

[Anonymous]

Thanks @v-ljerr-msft and @MattAllington .. It works..

[MattAllington]

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]

Table structure is same and all visuals are made from existing dataset query, so I need change data source Oracle to Sql for same dataset query. I don't want to go with new query.

[MattAllington]

---

@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.