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.
In this post, we would see how to import data from Excel file to SQL Server using Import and Export Wizard, we would import data from four excel worksheets to SQL server. Here are the steps:
1) Right click the Target Database > Tasks > Import Data to open the SQL Server Import and export wizard
2) select the Data Source. In this case, Excel file. You would select the worksheets to fetch data from later, for now – select the excel file as shown below:
3) choose the Target Database:
4) Select the tables (in our case- worksheets) or specify a query. For the purpose of this demo, we would go with “copy data from one or more table or views” option:
5) Select the worksheets from the Excel file and also specify the tables in the target systems. If the tables in the target database are not already created, then would be created by this wizard:
6) You have the option of running this wizard immediately or you have the option of creating a SSIS package and then run it later. For the purpose of this post, we would select Run Immediately
7) Review the information and click Finish
8) After successful execution:
In this blog post, we saw how to import data from Excel file to SQL server.
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.