How to get another table from the same sql data source without having to type the server name and database name again?
In power bi, how do I get another table from the same sql data source without having to type the server name and database name again?
Sorry if this is a very silly question, I am a beginner on this tool.
Let's say I already loaded one table from the database. Now I realize I need another table. I click the SQL server in the data section of the toolbar/ribbon:
When I do that I am again presented with this prompt asking me for the server name and database name again, when I already have this data source defined and connected. Why not a simple dropdown list? How do I simply pick a connection that I already added and browse the tables again?
Thank you.
Click Recent Sources right next to it. Alternatively, copy an existing query and delete all but the first couple of steps.
- How to apply RLS to other dimensions when using the static RLS approach?
- How to join columns from different tables and insert a calculated column in PowerBI / Power Query
- What does it mean by Power BI report references a row with RLS?
- Power BI - Dynamically generate queries
- Getting the next value of the same user if the type is "no type"
- Add a new column from value that is stored in a list of cell of the table
- Power Bi - Change font color of text in Matrix Visual
- PowerBI filtering rows from table visual when values are missing
- Developing PowerBI Visuals
- How to replace the value in same column - PowerBI query editor
- Unable to connect python script in PowerBI
- Combining Rows in Power BI/Power Query
- Eliminate customer with less than 2 products from the List
- How to filter a table based on a particular date in power BI
- MoM comparison on Area Chart results in +1 day
- DAX filter a Measure by an other Measure
- count distinct of 2 modalities at scale
- How to Set Default Collapsed State in Deneb-Vega Gantt Chart for Power BI
- Power BI calculate Measure for previous working day
- Calculate first date similar to sql window function in DAX
- User doesn't have permission to call the Discover method
- Changing the Color of a Set of Bars of a Clustered Column Chart
- Combining Measures from different Tables
- Distinct Count Rows with filter on Same column with Multiple Rows
- Configuring PowerBI on-premise gateway for SQL Server
- Creating a Music Podium top 5 - like visualization in Power BI from a table
- Using DAX to create a dynamic horizontal line for a bar or line chart in Power BI
- TypeError: Cannot read properties of undefined (reading 'tokenType')
- Sort Text Numbers in ascending in Slicer
- How to lookup Grades corresponding to Marks scored by students from a Grade-Slab table in Power BI?