Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create dataset with direct query for mln rows

Hello PowerBI experts.   Here is the case I need your help with. I have a data mart with mln records I would like to create a dataset with direct query to  it and published in power bi premium. To ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

What is your data source?

 

Regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

As a datasource I use Azure-hosted SQL DataMart.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    Do you mean Azure SQL Database? If so, it is possible to create live connection to Azure SQL DB, for details: Azure SQL Database with DirectQuery

     

    Regards,

    Yuliana Gu