Connect Additional Table to Existing DataMart Connection

Hello RamiAH , In Power BI Desktop, when you're using DirectQuery mode to connect to sources like Analysis Services (AS), you can't use the Transform Data (previously known as Query Editor) to modify the tables from the source. However, you can add additional tables from the same source without creating a new connection. Here's how you can do that:

Open Existing Connection:

Go to the "Home" tab in the Power BI Desktop ribbon.

Click on "Manage Queries" (or it might be called "Edit Queries" based on your version).

Then choose "Manage Parameters" from the dropdown.

Now you should see all your queries and connections on the left panel.

Modify Connection:

From the list of queries and connections, find and right-click on your existing DataMart connection.

Choose the "Advanced Editor".

In the Advanced Editor, you should see the M code that represents the current connection and tables.

If you're familiar with the M language, you can manually adjust the code to add the table you need. Otherwise, you can proceed to the next step.

Add Table Using Existing Connection:

Go back to the "Home" tab in the Power BI Desktop ribbon.

Click on "Get Data".

Choose your DataMart source (the same source type you've used before).

When prompted, choose the option to use an existing connection rather than establishing a new connection.

You should be taken back to the Navigator screen, where you can select the additional table you want.

Choose the table and click on "Load".

By following these steps, you should be able to add an additional table from your DataMart source without creating a new connection.

If you find this helpful, please provide a kudo and mark it as an accepted solution.