Create Your First Tabular Model | How to deploy your Tabular Model - SSAS Tutorial (5/15)

[@hlulaniwinners7076]

I have been struggling to have the working end-to-end demo for three months now. This playlist helped me a lot. Thank you so much for this.

[@johng5295]

Your explanation is second to none! It is very well structured, very well explained, and easy to follow. This is the nth time that I am revisiting this video in full. Thanks in a million my brother! Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++💥

[@AnalyticswithNags]

If you are in LinkedIn talk about this channel

[@Gold1996gold]

i have are errors in 11:34 , in the error it says there is no connextion established , but when i test connexion it is established

[@AnalyticswithNags]

It may be due to many reasons. Mostly the issue seems to be user rights to the database. Check the user access rights to those table or database

[@Gold1996gold]

i solved it , i register new login of (MSSQLSERVER) , my mistake was that i registered as login only MSOLAP$MOLAP user, in the end there are two services : (MSSQLSERVER) and MSOLAP$MOLAP to register

[@AnalyticswithNags]

@@Gold1996gold cheers

[@kausarali9852]

@@Gold1996gold how did you solve the error, kindly guide me

[@hendrag1174]

Hi Nag, I am at minute 10:42 and having some difficulties to setup service account. please advise as the video is not cleared. Thanks

[@AnalyticswithNags]

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

[@tnaresh5483]

hi can we connect the tabular model directly to power bi instead of ssms and excel as your using

[@AnalyticswithNags]

Yes. That is what live connection

[@sdeekshita3344]

Hi Sir, I have followed the installations as per your previous video but at 3:27 of this video, Workspace server is auto-populated for you, but in my system 'Localhost' is getting populated. In 'Analysis Services Deployment Wizard', which Database file has to be specified. Please let me know.

[@AnalyticswithNags]

I have workspace server SSAS installed, that’s why it appeared. Deploy with any name and try

[@harish7548]

Hi Nag, When I was going through some other videos I found lot of other folders like data source view,cubes, dimensions, etc ,why I can't find those folders here any ,why

[@AnalyticswithNags]

That's actually the multidimensional mode of SSAS cubes. As Microsoft recommends tabular model , the videos in this channel covered Tabular model only. The multidimensional model is not covered in the channel.

[@harish7548]

@@AnalyticswithNags makes sense thankyou

[@koushiksinha3007]

Hi Nags, If I connect to sql server and make a model in visual studio and want to deploy in azure analysis services why it is showing error saying "gateway required"? Can you please share your insights

[@AnalyticswithNags]

Of course. Since your SQL server is in on premise server you need to use gateway. Gateway enables you to secure transfer for onpremise data to Cloud. docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway

[@vinilamamillapalli9430]

@@AnalyticswithNags could you provide me contact details

[@ulrichatin1349]

Hello, thank you for your video but why you din't choose multidimentional model?

[@AnalyticswithNags]

SSAS Multidimensional not recommended by Microsoft

[@ErickNishimoto]

Nice job! Thx from Brazil! 💙

[@AnalyticswithNags]

Hearty thanks 🙏 Chennai, India

[@adamessaih7179]

Hey Bro, when i try to open the Model.bim it shows me an Error " Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Database.get_Mode()" what should i do to resolve the problem ? Thank you

[@adamessaih7179]

You only have to reinstall the version bevor the last one of the Analysis Services Software, this will solve the problem. It is a problem accured due to the update, so the one version befor work with no problem :D

[@AnalyticswithNags]

Hope its solved. Missed to reply.

[@adrianasantos6135]

Hi, Nag! Thank you for this excelent video!

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@superfreiheit1]

Why you do not use the SQL SERVER Developer Version?

[@AnalyticswithNags]

Yes. It was by mistake. You can use the developer edition

[@sagarchaurasia3342]

tabular model explorer is not showing in my visual studio.... how to solve that issue

[@AnalyticswithNags]

Watch the below video again. Watch this video after 12 mins. kzbin.info/www/bejne/bn3Ch5mCo9KIms0 Explained how to install data tools.

[@preethichamarthi8635]

Thank you nags it's pretty understable who r new to this

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@alikhan-su2jj]

hi, i have one problem, when I am going to deploy tabular model its give me this error Error: Cannot connect to the deployment database server 'DESKTOP-B3OPUQC'. Please verify the connection and try again. Reason: An error occurred while connecting to the server. ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Can you please help me to solve this one, thanks

[@AnalyticswithNags]

Go to services.msc. Search for SQL services Analysis service. Right click and check properties. In the display name you will find instance name. I.e SQL server Analysis service ( instance name). Then take this name and while deployment "DESKTOP-B3OPUQC\instance name" then try. Try to connect your SSAS server from SQL server management studio to ensure it is running

[@alikhan-su2jj]

@@AnalyticswithNags many thanks for your help, now its solved, i got one other issue, when i am going to deploy it gives me this error, "Cannot deploy to server localhost. Reason: The destination server version is not compatible with the compatibility level of the current model" when i start the new project i did not see any window to change the compatibilty of the model, can you please help me to solve this problem, many thanks

[@sravankumar1767]

here we used all log on credentials windows authentication. in real time we go for usename and password or windows authentication. impersonation information can we use service account or usename an password in realtime.

[@AnalyticswithNags]

It is based on your organisation security policy. Microsoft recommendation to use the service account

[@sravankumar1767]

@@AnalyticswithNags Thanks Nag

Hi, I've created a measurement table on a tabular mode. I reached the limit on this one, there is no more rows to included new measures. Is that possible to increase the number of lines?

[@AnalyticswithNags]

What I understand is you have created lot of measures. You don't have space to create new measures in the table. If my understanding is right? Then this is solution. You can create measures on another table also as the measures are not belong to specific table. It belongs to entire model. So you can create measures in other tables as well.

​@@AnalyticswithNags thank you for the answer. You understood correctly. I got another possibility, I created a new "fake" column in the original table and put the new measures there.

[@KarThik-tb1pl]

Hi Nags can we write dax using column from multiple tables ?

[@AnalyticswithNags]

Watch these videos. kzbin.info/www/bejne/hn_denhmacmEeac kzbin.info/www/bejne/oWXWe5Vnor6ka80

[@54tutu8]

07:11 mengisikan credential yg akan dipakai oleh server AS utk mengambil data dari data-source 08:46 menambahkan user (yg cred nya dipakai oleh server AS) ke database SQL (security) 10:17 sbg db_owner atau db_data_reader ? 19:18 peranan VS Data Tools di antara SQL DW dan SQL AS 22:15 kenapa di server AS terlihat ada tabular-model dg nama yg sama (yg satu punya suffix string random)

[@tanmoyhalder7397]

Hi Nag, Nice video. When im trying to create any measure, its getting created but no value is displaying. only showing "Calculation Error- Connection is not open"

[@AnalyticswithNags]

I hope you need to test the data source db and then try again

[@SagarMr1986]

I faced same issue. Check the server login name and database login and assign all roles except the roles starting with 'deny'. This resolved the issue for me.

[@ranganaik6421]

Can we import the data with custom query ? If yes please let me know the steps

[@AnalyticswithNags]

In 10 mins 40 sec choose the second option. Write query option

[@rameezriaz1697]

When you build the model and then deploy it, Is the data stored in the RAM of the computer?

[@AnalyticswithNags]

No incase of SSAS the deployment happens in the server. That is why we installed SSAS tabular instance in the first video in the playlist

[@alikhan-su2jj]

n i got one other issue, when i am going to deploy it gives me this error, "Cannot deploy to server localhost. Reason: The destination server version is not compatible with the compatibility level of the current model" when i start the new project i did not see any window to change the compatability of the model, can you please help me to solve this problem, many thanks

[@AnalyticswithNags]

Either Analysis service not running / you are using the in compatible version of Visual studio

[@sravankumar1767]

Hi Nag can you do one real time project on SSAS Tabular, either support or Enhance project..

[@AnalyticswithNags]

Sure will do soon

[@venkateshthammisetty7845]

Hi, If possible can u pls make a video on migrating PBI data model (Premium dataset, XMLA Endpoint connected) to Tabular Model.

[@AnalyticswithNags]

I never tried. But this should logically should work In visuals studio data tools.. Analysis service projects > import from tabular model option > provide power bi dataset server. Then you can import it as tabular model. Try and let me know if it works

[@venkateshthammisetty7845]

@@AnalyticswithNags, we can't import from Premium dataset only can import from Analysis services.

[@venkateshthammisetty7845]

Hi Can u pls let me know if u aware of , what is the use of the annotations in XMLA script, u will find these in XMLA script of Tabular Model?

[@bijilashobanabalakrishnan7718]

Hi Nag, Thanks for the series videos! I created a calculated column in SSAS model date table to find default ‘current quarter’. It showed up in the model. But when I deployed and pulled(live connection) to Power BI it is not displaying in the visual. It is an error occurred. But when I use this logic and created the column in Power BI directly it is working fine. What could be the issue? Could you please help me to understand it. I can provide calculations used and the error message if you need it to understand better.

[@AnalyticswithNags]

If it is calculated column , just change the model again and refresh.

[@bactran7799]

Great video to learn SSAS tabular. Thank you Nags

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@petecarl7486]

Brilliant demo thanks

[@AnalyticswithNags]

Thank you Keep Learning

[@is2ken]

The Sale amount - The Tax amount equals to the profit? I think it should be the gross income.

[@AnalyticswithNags]

That’s true. It is just for understanding how measure works

[@is2ken]

Anyway, I love the video. Thanks for the hard working.

[@jowdelgado6865]

Good video. Question on the fact table, did you model the data in the fact table as unpivoted data?

[@AnalyticswithNags]

It is designed in database. The fact and dimensions tables I meant

[@munabhaibit]

Excellent explanation. I am learning a lot from you.

[@AnalyticswithNags]

Happy to hear this. Keep learning. Share this Channel with friends and colleagues

[@alexeyzholobov8088]

Very good! Thank you

[@AnalyticswithNags]

Thanks keep learning

[@sravankumar1767]

Hi Nag, ca u please do some real time projects on ssas tabular like development, enhancement , migration ..

[@AnalyticswithNags]

When time permits we will plan for it.

[@sravankumar1767]

@@AnalyticswithNags Thanks

[@pvarunkumar8106]

Gud explanation...sir, if don't mind..please make a full video , brief about MSBI, POWER BI, SSAS,SSIS,SSRS,AZURE,.and also Data warehouse.not indepth to each n every.Because, as a frsher ..I confused.waht is what. Which is connection to which, I mean relation between all among them. Which softwares we need to install for each one. 🙏🙏

[@AnalyticswithNags]

Watch this video to understand better KNOW WHY !!! Power BI alone NOT enough to get a JOB [ Most asked Question to US]

[@ravitejak9414]

Hi Sir, i want to learn Dynamic RLS using Tabular model i hope this playlist would help me on that. Thanks.

[@AnalyticswithNags]

Yes, sure

[@krishnakanth4265]

Hi Nagendera! Thanks for the video, can you please paste the adventure work database source file in the link description, if possible.. Thanks in advance.

[@AnalyticswithNags]

docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

[@krishnakanth4265]

@@AnalyticswithNags thanks for the source link..CHEERS..!!

[@vvkreddy9133]

I got all errors after running fact internet

[@AnalyticswithNags]

Not sure what error you are getting. Ensure user used to connect to database have all right. It should be impersonation issue.

[@segunlonge3886]

Thank you!!!

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@sravankumar1767]

can you make videos on ssis.

[@AnalyticswithNags]

Will be uploading the video series on SSIS this week

[@sravankumar1767]

@@AnalyticswithNags thank u, somebody has removed in what's app group , how should i post my doubt if i get, recently i got a job. i want to share with you some doubts

[@AnalyticswithNags]

@@sravankumar1767 Join in telegram t.me/analyticswithnags

[@shubhan_0]

Data is my asset

[@AnalyticswithNags]

yes

[@tomasvanecek89]

Good presentation, but: please learn english pronunciation.

[@AnalyticswithNags]

Sure. Thanks keep learning share this channel with friends and colleagues