Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
latheesh89
Helper II
Helper II

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

 

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
mgmeyer
Power BI Team
Power BI Team

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.

Unfortunately this forum is for the on-prem Power BI Report Server, you can try to submit your question to the service forum here:

 

http://community.powerbi.com/t5/Service/bd-p/power-bi-web-app

 

You'll probabaly get more traction there. Thanks!

v-yulgu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors