44 Views

20th April 2020

How do I create an azure analysis service?

Hoping someone can help me, How to create first data model in azure analysis services?

Answers

28th April 2020

Answered by rushi chowdary

To create Azure Analysis Services data models, you will use Visual Studio and an extension called SQL Server Data Tools (SSDT).

1. In SSDT, create a new Analysis Services Tabular Project.If they asked to select a workspace type, select Integrated.

2. After that click the Import from Data Source icon on the toolbar at the top of the screen.

3. Then select Microsoft SQL Azure as your data source type and click the  Next.

4. Fill in the connection information for the sample SQL Azure database created earlier and click Next.

5. Now select Service Account for the impersonation mode and click Next.

6. Finally select the tables you wish to import into cache and then click Finish

 

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos