cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jibran Regular Visitor
Regular Visitor

Remove the data source

Hi,

 

How can I remove previous data sources in Power BI Desktop.

Actually I am getting an error when I try to connect to Oracle Database since morning, actually we upgrade database and add new port to the database. 

Since then I am getting following error.

Is there anyone else encountered the same thing before?

 

 

 

Oracle Error.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Remove the data source

Hi @jibran,

 

You can remove the data sources in the current file or previous used data sources in desktop. You can go to File-> Options and settings-> Data source settings loike below:

q3.PNG

 

Best Regards,
Qiuyun Yu

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
PavelR Established Member
Established Member

Re: Remove the data source

Hi @jibran,

 

in Edit queries window, you delete your query.

 

Regards.

Pavel

Moderator v-qiuyu-msft
Moderator

Re: Remove the data source

Hi @jibran,

 

You can remove the data sources in the current file or previous used data sources in desktop. You can go to File-> Options and settings-> Data source settings loike below:

q3.PNG

 

Best Regards,
Qiuyun Yu

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

garrek99 Frequent Visitor
Frequent Visitor

Re: Remove the data source

I have a similar problem and was hoping you could help.

 

I have 2 data sources in the Data Source Settings page (like the one in your image). And the sources are the same except one is in all caps and one isn't. For some reason Power BI sees these 2 as distinct even though the connection strings are identical (password and uname). Because of this the Delete command is just ignored. I tried deleting either and realized I can try deleting both at the same time but nothing works.

 

Any ideas? 

bchager Frequent Visitor
Frequent Visitor

Re: Remove the data source

How this actually explains how to remove a data source escapes me...

bchager Frequent Visitor
Frequent Visitor

Re: Remove the data source

How this actually explains how to disconnect from a data source escapes me...

jibran Regular Visitor
Regular Visitor

Re: Remove the data source

Hi,

On your Power bi Desktop Go to File -> Options and Settings -> Data Source Settings.

It will take you to the data source page there you can delete the data base source.

Click on edit permission which will open another pop up that allows you to delete the source as shownData Base Deletion.PNG

Highlighted
marialester19 Occasional Visitor
Occasional Visitor

Re: Remove the data source

I do not have those options. Thoughts? 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 138 members 1,559 guests
Please welcome our newest community members: