Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Model in SSAS Tabular or in Power BI when using Direct Query

Hi,    I am exploring Direct Query at the moment. The question I want to ask is which option would be better:   1. Put model in Power BI and connect it with Direct Query to SQL Server 2016. 2. P...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

 

Per my knowledge, method 1 that establish live connection to SQL Server directly from Power BI might be better. It could load data faster than using method 2.

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi, 

     

    Thank you for the response. In the end I will have to test it.

     

    Regards, 

    Vasil