SSAS Tabular Model Power Query

[vinitpawar99]

I'm Creating an Analysis Service Tabular Model in Visual Studio
I'm not able to view all the imported tables in Power Query Editor(SSAS). It only allows me to open one table in the Power Query

Case : -
I have created a tabular model in which I have imported some tables.
Now I want to perform merge between two tables with Power Query Editor but it only allowing me to open one table in the Power Query View.
Please let me know how I can again open the Power Query Editor to perform the merge operation

[v-jingzhang · Accepted solution]

Hi @vinitpawar99 

This article should be helpful: Quirks of Visual Studio Query Editor working with Analysis Services – business intelligist

If you were to open the Query Editor screen for another table in the Tables folder, you will not see any other tables, but you will see the new (shared) Expression. With this, you can merge, append, or do whatever else you’d like.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[vinitpawar99]

Thanks for your help @v-jingzhang 

[BA_Pete]

Hi @vinitpawar99 ,

It sounds like you are connecting to your Tabular model using a live connection, rather than importing specific tables.

When connecting to ANY source with a live connection, Power Query is completely bypassed.

Please see here for details on different connection methods:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data 

Pete

[vinitpawar99]

@BA_Pete  Thanks for response.
I'm Creating a Analysis Service Tabular Model in Visual Studio
My Comments : - I have imported all the tables after the transformations.

Now, I want merge two tables but, I'm able to open only one table in the Power Query, How can I see all the imported tables in Power Query