Create Your First Tabular Model | How to deploy your Tabular Model - SSAS Tutorial (5/15)
Vložit
- čas přidán 1. 12. 2020
- MSBI Tutorial for Beginners SSAS Tutorial for Beginners
What is tabular model and how to create your first tabular model
What is integrated workspace server in tabular model
Create and deploy the tabular model in SSAS analysis server
#MSBI #SSASTutorial #SSASTabular #SSASTabularModel #SSAS #SSASCube
Adventure works database
docs.microsoft.com/en-us/sql/...
🏬 Reference Books : www.amazon.in/shop/analyticsw...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da... - Věda a technologie
![[[ 3.1 HOURS ]] SSAS Complete Tutorial - End to End - SQL Server Analysis Service](http://i.ytimg.com/vi/RWtfutxe4zc/mqdefault.jpg)
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++💥
If you are in LinkedIn talk about this channel
Excellent explanation. I am learning a lot from you.
Happy to hear this.
Keep learning.
Share this Channel with friends and colleagues
Hi, Nag! Thank you for this excelent video!
Thanks keep learning share this channel with friends and colleagues
Thank you nags it's pretty understable who r new to this
Thanks keep learning. Share this channel with friends and colleagues
Great video to learn SSAS tabular. Thank you Nags
Thanks keep learning. Share this channel with friends and colleagues
Nice job! Thx from Brazil! 💙
Hearty thanks 🙏 Chennai, India
Very good! Thank you
Thanks keep learning
Brilliant demo thanks
Thank you Keep Learning
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.
If it is calculated column , just change the model again and refresh.
Good video. Question on the fact table, did you model the data in the fact table as unpivoted data?
It is designed in database. The fact and dimensions tables I meant
Data is my asset
yes
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.
I have workspace server SSAS installed, that’s why it appeared. Deploy with any name and try
Thank you!!!
Thanks keep learning share this channel with friends and colleagues
Hi Nags can we write dax using column from multiple tables ?
Watch these videos.
czcams.com/video/PNzIE04dQCE/video.html
czcams.com/video/k4sJb1mYq5k/video.html
When you build the model and then deploy it, Is the data stored in the RAM of the computer?
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
hi
can we connect the tabular model directly to power bi instead of ssms and excel as your using
Yes. That is what live connection
Hi Nag can you do one real time project on SSAS Tabular, either support or Enhance project..
Sure will do soon
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?
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.
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
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
@@AnalyticswithNags could you provide me contact details
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.
docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms
@@AnalyticswithNags thanks for the source link..CHEERS..!!
Can we import the data with custom query ? If yes please let me know the steps
In 10 mins 40 sec choose the second option. Write query option
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
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.
@@AnalyticswithNags makes sense thankyou
Hi Sir,
i want to learn Dynamic RLS using Tabular model i hope this playlist would help me on that.
Thanks.
Yes, sure
Hi,
If possible can u pls make a video on migrating PBI data model (Premium dataset, XMLA Endpoint connected) to Tabular Model.
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
@@AnalyticswithNags, we can't import from Premium dataset only can import from Analysis services.
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?
Hi Nag, ca u please do some real time projects on ssas tabular like development, enhancement , migration ..
When time permits we will plan for it.
@@AnalyticswithNags Thanks
tabular model explorer is not showing in my visual studio.... how to solve that issue
Watch the below video again.
Watch this video after 12 mins. czcams.com/video/8L_VfLnmUdk/video.html
Explained how to install data tools.
Why you do not use the SQL SERVER Developer Version?
Yes. It was by mistake. You can use the developer edition
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. 🙏🙏
Watch this video to understand better
KNOW WHY !!! Power BI alone NOT enough to get a JOB [ Most asked Question to US]
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
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
Hope its solved. Missed to reply.
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
Either Analysis service not running / you are using the in compatible version of Visual studio
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.
It is based on your organisation security policy. Microsoft recommendation to use the service account
@@AnalyticswithNags Thanks Nag
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
Explore the similar problems here, learn.microsoft.com/en-us/answers/
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"
I hope you need to test the data source db and then try again
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.
can you make videos on ssis.
Will be uploading the video series on SSIS this week
@@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
@@sravankumar1767 Join in telegram t.me/analyticswithnags
The Sale amount - The Tax amount equals to the profit? I think it should be the gross income.
That’s true. It is just for understanding how measure works
Anyway, I love the video. Thanks for the hard working.
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
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
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
@@ilyeseljawhari4969 cheers
@@ilyeseljawhari4969 how did you solve the error, kindly guide me
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
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
@@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
I got all errors after running fact internet
Not sure what error you are getting.
Ensure user used to connect to database have all right. It should be impersonation issue.
Good presentation, but: please learn english pronunciation.
Sure.
Thanks keep learning share this channel with friends and colleagues
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)