How do I change the query that’s being used to populate tables in SSAS Tabular Model?
Here are the steps that you need to follow:
1. After you’ve the solution open in SQL Server Data Tools, go to menu > Table Properties
2. On the Edit Table Properties, you can change the query. you can also change the tables if that’s what you have used using the “switch to” box on the right side of the dialog box.
3. If you need to change the server name or instance, used then you will need to modify the connection, for that go back to menu bar and click on Model > Existing Connections. you should be able to edit the connection from here:
In this post, you saw how to change the query used for the tables in SSAS Tabular models.
Some year’s ago – I got introduced to SQL. At that time, I recall, I was sitting in a lab and one of the first exercises we did was to create a table in a database and adding data in it. In next lab, we ran SQL commands that updated records and deleted few. After we’re done – our instructor told us what we learned were the most basic programming functions i.e CRUD operations
CRUD stands for Create, Read, Update and Delete.
Let’s see the SQL equivalent of CRUD operations:
Is the concept of CRUD just applicable to SQL?
No. in fact, if you start learning programming or web development – one of the first things that you get to learn is how to run CRUD operations with that particular language.
In this blog post, I documented four (4) basic programming functions i.e. Create, Read, Update and Delete.