DirectQuery in Analysis Services: Best practices, performance, use cases

if you have large data set which cannot loaded to PowerBI model then available options are DirectQuery or Live connection, the best way is to define your data model in the data source and connect to PowerBI,

Microsoft has given Analysis Service both on-prem as well as Azure to get the same experience , Tabular model becoming a more popular and the same technology is being used PowerBI too ( both using same in-memory engine )

for more details on DirectQuery in AS refer below

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *