Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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. 

1 ACCEPTED SOLUTION

 Hi @Anonymous,

 

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

advancedEditor.PNG

 

Regards

View solution in original post

10 REPLIES 10
v-ljerr-msft
Employee
Employee

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 

Anonymous
Not applicable

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 ?

Anonymous
Not applicable

Can you tell me the steps.

 Hi @Anonymous,

 

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

advancedEditor.PNG

 

Regards

Anonymous
Not applicable

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

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. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Anonymous
Not applicable

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.


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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.