Wednesday 2:00 PM - 3:10 PM · Room 344

PowerBI, DirectQuery and SQL Server. It is a good choice?

Jose Manuel Jurado Diaz

Microsoft, Escalation Engineer, Azure SQL Database and Manage Instance

Juan Moreno Romo

Microsoft, Support Escalation Engineer, Azure SQL Server Hybrid

You will learn best practices, tips and tricks on how to successfully use SQL databases (OnPremise,IaaS, PaaS,SQL Managed Instance) with PowerBI on production environments.

How improve the performance, using for example, Read-Scale, HyperScale or Synapse, partitioning, ColumnStoreIndexes, Indexed views, etc..

How to monitor and diagnostic your database and find out issues with Query Data Store. These learnings are fruit of Microsoft CSS support cases, and customer field engagements.