Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Gilbert,
Microsoft confirmed to me today that this feature is not yet available for Integration service projects.Pls look below:
Also it cant be acheived using REST API.
For PRO License you can try something like this, the same connector exists in SSIS:
https://freesbi.wordpress.com/2022/01/11/conexion-en-modo-import-a-un-dataset-de-power-bi-publicado/
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 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.
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.
Gilbert,
Microsoft confirmed to me today that this feature is not yet available for Integration service projects.Pls look below:
Also it cant be acheived using REST API.