SSAS Tutorial (8/15) - How to Import Few columns From a table

[@donsls]

Thanks for these great videos. I am learning a lot. I have a stored procedure that returns 700+ columns for a particular dataset. What will be the reccomendation when bringing the table into SSAS? Should I break the table into multiple small tables (250 columns each) before bringing it to SSAS? If so, how will the star schema work in this case?

[@AnalyticswithNags]

I am pretty much sure that procedure uses joins from many tables. Better to bring those tables and model it here

[@sameerunawane]

How to create a copy of ssas solution for different data source. I am unable to do it

[@jilanjillujillu8719]

Hi bro I have Dimperson table in existing cube Here we need to add company name column Can you please suggest

[@AnalyticswithNags]

Go the table. Right edit. Add column in power query/ refresh. Then press import metadata the new column will appear

[@jilanjillujillu8719]

Hi bro In this case we have Dimperson table in that we have one campany I'd column is their, We need to add company name in cube level, We have company name table is their can it possible to build relationship in cube level

[@abdulkhadershaik4738]

I have been the Tech Lead on Tableau, MicroStrategy for 10+ years with 1 year experience on Power BI. Can you suggest how difficult or easy it will be to move as Tech Lead for a project with SSIS, SSAS, Power BI tool stack where I have to contribute in all areas from scratch. Need your guidance to accept the opportunity or not ?

[@AnalyticswithNags]

you will have all the concepts knowledge only tools differ, go ahead with offer

[@rowthulaphani4473]

Hi bro, i have one doubt, pls clear me. In the table properties there is switch to option, in there you have table preview, but i have query editor, it doesn't show the preview of table, how can i change it??

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/