SSAS Tutorial (7/15) - How to Import New tables in SSAS tabular Model | Manage Relationship

[@MultiAllaeddine]

Great explanation, keep up

[@AnalyticswithNags]

Thanks, will do!

[@bharathareddy7446]

Hi Nag, If we have data in some table that is not available in the existing DB(ADV database ) then how to Import to those tables to this Model and how can we give Relationship to it.

[@AnalyticswithNags]

Not sure , what is your exact question where you are not seeing the table.

[@donsls]

Can I create 2 star schemas on the same model? Ex: I have 2 data sources. Invoice and Employee. There are no links between these 2 data sources. I want to create the required star schema for Invoice and then another one for Employee. Again there are no links between these two. But I want to deploy both these into the same SSAS database? If I do different VSS projects, they will go to 2 different databases in SSAS. Is there a way to deploy both these to the same SSAS database? Apologies, if this is a stupid thing to do. But I wanted to know the possibility and pros and cons.

[@AnalyticswithNags]

Yes you can have two start schema in same tabular model

[@sravankumar1767]

hi Nag, i have one doubt that i asked one question about my friend one of the scenario. he is Gettng new tables from excel then it comes to SQL SERVER THEN THEY CREATED INDEXED VIEWS AND THEN INTEGRATED TO ADF AND FINALLY IT COMES TO AZURE ANALYSIS SERVICES. HOW SHOILD WE FIND NEW TABLES ADDED IN AAS. IS IT LIKE YOU SAID IMPORT NEW TABLES BOTH ARE SAME OR DIFFERENT. CAN YOU EXPLAIN IT BRIEFLY.

[@AnalyticswithNags]

You question is bit confusing. Kindly write to us [e-mail] . Also, mention where and why you have to identify new tables added in AAS?

[@sravankumar1767]

@@AnalyticswithNags I has put a mail please check it and reply nag. how to identify new tables in AAS

[@hendrag1174]

Hi There, please advise how to have AdventureworksDW? I am using SQL Server 2019 Developer and already have Adventureworks 2019 in my SQL Server 2022 Express. Look forward to hearing from you. Thanks

[@AnalyticswithNags]

you can download online, database/powerbi/ssis/ssas/scripts/azure/app everything under here - - > github.com/microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers

[@ankithsimha9073]

Hi nag. I have a question, imported data from SQL excel, after loading I need to clean the data. Here I didn't find out the option like power query in power bi. Can you help me on that.

[@AnalyticswithNags]

You need to use latest compatibility level. Then power query option in available. Watch this I explained that in this Video kzbin.info/www/bejne/eqLSpIZvntujhtk