Visual Studio as Semantic Layer - Live Connection, Backup in Azure DevOps, Best Performance

  • Monday, October 10, 2022:2:00 PM - 2:45 PM
  • Room: Osceola 1 - Convention Center, Level 2
  • Session Number:  574


This presentation will start with a connection between Visual Studio and SQL Server to get some tables, then make a relation between those tables, add some calculated columns and measures in DAX, then deploy the project and make the connection to Power BI as a Live connection, then back up the project in Azure DevOps. To finalize will show some examples of projects with lot of data and relationships.

Complete Session Survey Here

Learning Objectives

- A new option of Semantic Layer.
- Work with Live Connection.
- Work with data source "Analysis Services".
- Connect the Semantic Layer to Azure DevOps.



Alberto Alvarado
BI Specialist
Wholesum Family Farms Inc