Reusing the Database connection for multiple table imports

[Anonymous]

Hi Team,

I am new to POWER BI...I have 10-15 database tables and I need to import data from these tables.

Do I need to provide server name and databse name everytime , I do this?

is there no way , I can reuse already provided details?

I hope to get answer soon.

Thanks and Regards,

raghu

[Anonymous · Accepted solution]

Hi @Anonymous ,

try below 

1. In the "Query Editor" window, click on the "Edit" button in the "Home" tab to open the Power Query Editor.
2. In the Power Query Editor, click on the "Home" tab.
3. Click on the "Advanced Editor" button in the "Home" tab to enter your custom query.
4. In the Advanced Editor window, you can directly write your query to retrieve data from the database.
5. Once you have entered your query, click on the "Done" button to close the Advanced Editor.

Power BI will then execute your query and import the data into the data model. You can perform further transformations and modeling on the imported data as needed.

[Anonymous]

Hi @Anonymous ,

try out below steps

In Power BI, you can reuse the server name and database name when importing data from multiple tables. Here's how you can achieve this:

1. Get Data: In Power BI Desktop, go to the "Home" tab and click on "Get Data" from the "External Data" section.

2. Select Database: In the "Get Data" window, select the appropriate database type you want to connect to (e.g., SQL Server, MySQL, Oracle, etc.). Choose the specific database connector based on your database type.

3. Connection Details: In the next window, you will be prompted to enter the server name and database name. Provide the necessary information to establish the initial connection to the database.

4. Data Import: Once the connection is established, you will be presented with a navigator window that allows you to select tables or views from the connected database. Choose the tables you want to import into Power BI.

5. Query Editor: After selecting the tables, Power BI opens the Query Editor window, where you can apply transformations, filters, and other data shaping steps before loading the data into your Power BI model.

6. Close & Apply: Once you have finished shaping the data in Query Editor, click on the "Close & Apply" button to load the data into Power BI.

[Anonymous]

Hi @Anonymous ,

Thank you for the detailed steps.That works for me for few of the tables.

But I also have queries to be passed for few more imports. Every time I am repeating steps 1,2 and 3 mentioned by you above and then I click on advanced option and enter the query.

So in this case is there any way I can skip entering Server name and Database name and directly enter the query and import the data as I would be connecting to the same databse always.

Appreciate your help.

Thanks and Regards,

Raghu