Forum Discussion

latheesh89's avatar
latheesh89
Helper II
8 years ago
Solved

Load Power BI datasets to SQL table

Dear Techies,   I would like to consume the dataset to SQL tables. Is there a way to achieve this?   I have done the following    1. Register an app with Azure AD 2. Get an authentication acce...
Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi latheesh89,

     

    Based on my research, we could export Power BI dataset to SQL Server using R or SSIS. If your dataset is hold on service, you could first download it to desktop.

     

    For more details, please refer to: EXPORTING POWER BI DATA TO SQL SERVER

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi latheesh89,

 

Based on my research, we could export Power BI dataset to SQL Server using R or SSIS. If your dataset is hold on service, you could first download it to desktop.

 

For more details, please refer to: EXPORTING POWER BI DATA TO SQL SERVER

 

Best regards,
Yuliana Gu

  • latheesh89's avatar
    latheesh89
    Helper II
    8 years ago

    Thanks Yuliana for your valuable suggestion. Yes I agree that is one way of doing but, I am looking for one stop solution rather going to on-prem.

     

    Thanks again!