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

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!

latheesh89's avatar
latheesh89
Helper II
8 years ago

Yes, I am trying to do it from PBI service.