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 access token

 

Next step is to use Getdataset() to read the data and load it to SQL table. I'm stuck here. Can you please help me

 

Thanks,

Latheesh

 

Help

5 Replies

  • 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!

  • mgmeyer's avatar
    mgmeyer
    Power BI Team
    8 years ago

    Hey Latheesh, if I understand your question it looks like your trying to get data from and existing AD app and then push the data to a SQL table either on-prem or in Azure, is that correct? Also are you trying to do this from the PowerBI service or our on-prem PowerBI Report Server offering? Thanks!