cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pBI1234
Helper IV
Helper IV

query PBI dataset residing in workspace using Rest API or another approach?

Hi,

I would like to know if there is a way to extract the required data by querying the PBI dataset residing in premium workspace using REST api.I do see some endpoints offered by MSFT for doing set of operations using API but couldnt find anything online to query/read a dataset.

I want to have a way to be able to do the above and further automate.I tried to see if there are ways usin c#,powershell ,SSIS but unfortuntely i dont find any option.

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

Hi @pBI1234 

 

The only way I know of to do this is to use SSIS to do this here is my blog post

 

How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV - R...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User II
Super User II

Hi @pBI1234 

 

The only way I know of to do this is to use SSIS to do this here is my blog post

 

How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV - R...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors