Process a SSAS Tabular Cube // Multiple Ways

[@KahanDataSolutions]

Want to build a reliable, modern data architecture without the mess? Here’s a free checklist to help you → bit.ly/kds-checklist

[@kelek22]

Hey do you know how to configure SSAS so I can connect to it from a powerBI in another server

[@xandr4870]

Finally, some actually easily digestable SSAS youtube content. There is virtually nothing out there. Lifesaver!

[@navbi9907]

Man, beautiful video. Short concise and to the point and well covered with all the options.

[@KahanDataSolutions]

Much appreciated!

[@pabeader1941]

A year later and still helpful. Answered my exact question without me even having to ask. Thank you for posting this video.

[@KahanDataSolutions]

Glad it helped!

[@gerhardsamstag5032]

Great, Great and Great! This is the Solution of one of my Problems. Please more of SSAS Tabular Topics.

[@KahanDataSolutions]

Awesome!

[@TAIMIUWU]

Brilliant work. Very useful tips. Thanks for putting up this video.

[@KahanDataSolutions]

Glad it was helpful!

[@humanbeing3062]

Awesome content! Thanks for sharing!

[@KahanDataSolutions]

Thanks for watching!

[@samuelminamioka5393]

Very good video, bro! Thank you very much

[@KahanDataSolutions]

Thanks for watching!

[@chandrashekaryennedla6409]

Thanks a lot . As usual awesome content

[@DionnyPrensa]

Thanks, Michael. It has helped me a lot. Now, I need to automate the Code Deployment instead of Data. For example: Add or remove a Measure. I need to deploy the changes, but I don't want to use my laptop to deploy the code and the new data.

[@arturrubets]

You are the best!

[@KahanDataSolutions]

Thank you!

[@mrgogate]

Thank you... it was helpful!!

[@KahanDataSolutions]

Glad it helped!

[@abolfazlhosseinzadeh2732]

I'd stocked at the role part so my job couldn't be done. thanks for the details in your videos ❤

[@danilocampana]

thanks for the video, would it be possible to teach you how to configure auto-update in Azure SSAS

[@KahanDataSolutions]

Hi Danilo, thanks for watching! I'm planning on adding some Azure SSAS content in the future and will keep this in mind.

[@viniciusferreira6807]

minute 3:21. what to do when objects are not selectable?

[@abhiveer6353]

@kahanDatasolutions - Can you please share the ways to process MDX cube from Azure Data Factory

[@thomashannoveraner356]

Hi. Whats the difference between refreshing in SSMS and deploying in Visual Studio. Create and deploy refreshes my Cube Dimensions also I think?

[@KahanDataSolutions]

Hi Thomas, yes they should operate the same in that scenario

[@nagelfamily]

does “full” add in newly created columns?

[@noahhadro8213]

Does process full drop all partitions and reload them or does it honor incremental refresh?

[@HeshamNasser0]

which solution is better in protective of memory ?

[@gwenhumphrey1968]

Great vid. How do I close a cube no longer needed?

[@KahanDataSolutions]

Thanks Gwen! Are you talking about dropping the entire cube from your server? If so, you should be able to just do a right-click + delete from SSMS if needed.

[@jurajcichansky2578]

Great video. Is there a way how to process 2 cubes at once? Thanks

[@KahanDataSolutions]

Thanks! You should be able to process multiple by running two of the SSIS components in parallel or have two SQL Agent jobs triggered at the same time but pointed to different cubes.

[@abcthegreat1]

Can SSIS be used when model lives on power bi premium. (can you point SSIS to the the premium workspace URL)

[@rafibasha4780]

refreshing a partition in a script mode?

[@marounsader318]

hi im having the same error but when i run SSIS pckg, can you please help or refer me to a reference to fix it

[@billysun1059]

Hi，Guys, I have an error message "DDL is not valid" after I paste the code from SSMS to SSIS Analysis DDL task, any idea?

[@theheritageleatherco5812]

How do I process a cube if I don't have access to SSIS, and I don't have access to the SQL Server Agent to create a job? Do you know of way to do this through Powershell or something else?