Forum Discussion
SSAS Tabular Model Power Query
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
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.
4 Replies
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.Thanks for your help v-jingzhang
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
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
