Forum Discussion
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...
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
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!
Yes, I am trying to do it from PBI service.