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

connect to powerbi dataset in service from ssis

Hi,

I am trying to find out the steps to connect to powerbi dataset residing in the powerbi workspace in ssis but no clear instructions so far.Can someone please include the steps.Also would it be possibe to trigger refresh from sql agent job to refresh the SQL table results courcing this DAX query from dataset.

I see posts using REST services but just dont have clear instructions.

1 ACCEPTED SOLUTION

Gilbert,

Microsoft confirmed to me today that this feature is not yet available for Integration service projects.Pls look below:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools#data-modeling-and-mana...

 

Also it cant be acheived using REST API.

View solution in original post

10 REPLIES 10
Frequent Visitor

That stinks

Super User II
Super User II

Hi there

As far as I know it is not possible to connect to the datasets from SSIS. There are REST APIs which can do certain functions but as far as I know cannot connect via SSIS

The only way would be if you are running Power BI Premium and you connect via the XMLA end points.




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

Proud to be a Super User!







Power BI Blog

Thanks Gilbert.Can you elaborate on using XMLA end points to connect to powerBI dataset in premium workspace and get a subset of data from dataset into SSIS (DAX query)

Hi there

What I have done in the past is to use an OLE DB connection to an SSAS Tabular Instance.

Then using the OLD DB Source I can then put in my DAX query, which will return the dataset. I can then put this into a SQL Table within SSIS

XMLA allows you to connect to the dataset, which is available in Power BI Premium, and is almost the same as SSAS Tabular




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

Proud to be a Super User!







Power BI Blog

Hi Gilbert,

It is not working the same way it is working with SSAS Tabular or Azure SSAS.It complains of the initializing provider when i chose MS provider for Analysis Server 13/14.So i am not sure if .NET /OLE db provider allows connection to the powerBI sources as i see many posts that say feature is not yet available to read dataset on powerBI from certain apps .They say  REST API operations too are limited to only few functions with respect to dataset.

If you could confirm that it is possible or not with XMLA,it will be really helpful to me.

Hi there

Please make sure you have got the latest versions of the OLE drivers installed.

You can download and install them here: https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers




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

Proud to be a Super User!







Power BI Blog

Gilbert,

I am able to connect to Azure AS tabular model using these existing libraries in my machine,Not sure why same doesnt work for powerBI dataset.

Would like to know if you have tried to connect to powerBI dataset from ssis.

Hi there

I have connected to other SSAS instances in the past and this should be no different.




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

Proud to be a Super User!







Power BI Blog

Gilbert,

Microsoft confirmed to me today that this feature is not yet available for Integration service projects.Pls look below:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools#data-modeling-and-mana...

 

Also it cant be acheived using REST API.

View solution in original post

Thanks for letting us know!




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors