Forum Discussion
Reusing the Database connection for multiple table imports
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...
Hi Anonymous ,
try below
- In the "Query Editor" window, click on the "Edit" button in the "Home" tab to open the Power Query Editor.
- In the Power Query Editor, click on the "Home" tab.
- Click on the "Advanced Editor" button in the "Home" tab to enter your custom query.
- In the Advanced Editor window, you can directly write your query to retrieve data from the database.
- 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.
Hi Anonymous ,
try below
- In the "Query Editor" window, click on the "Edit" button in the "Home" tab to open the Power Query Editor.
- In the Power Query Editor, click on the "Home" tab.
- Click on the "Advanced Editor" button in the "Home" tab to enter your custom query.
- In the Advanced Editor window, you can directly write your query to retrieve data from the database.
- 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.