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

Power BI Desktop Edit Queries Recent Sources not showing current Datasource

I am using Power BI desktop to connect to an Azure SQL Database in Direct Query Mode.

 

I want to add another query to connect to another table or view in the current datasource.

 

When i click on Recent Sources to select the current data source so i can get a list of tables and views from the database, the current datasource is not in the list, even after clicking more.

 

This is preventing me from being able to add additional tables / views to the existing model.

 

Is there a way to refresh the list of recent sources to include the current datasource or alternatively is there a way to add additional tables or views without having to go through the list of recent datasources.

 

Thank you

4 REPLIES 4
Highlighted
Community Champion
Community Champion

Re: Power BI Desktop Edit Queries Recent Sources not showing current Datasource

@mrhodes can you Close&Apply to get out of query editor and then look under Recent Sources to see if that is available ?

Highlighted
Regular Visitor

Re: Power BI Desktop Edit Queries Recent Sources not showing current Datasource

No, i have tried to close and apply, tried exiting the desktop designer tool and going back in. I also uninstalled and reinstalled power bi desktop. no changes in the list. I am also on the current version of the tool as well.

 

 

Highlighted
Microsoft
Microsoft

Re: Power BI Desktop Edit Queries Recent Sources not showing current Datasource

@mrhodes

 

I reproduced your issue. The Direct Query connection to Azure SQL database can't be displayed in Recent Sources while other created connection are displayed properly. We will report this issue internally.

 

Regards,

Highlighted
New Member

Re: Power BI Desktop Edit Queries Recent Sources not showing current Datasource

Im having the same problem. When will this be fixed?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors