Refresh PBI dataset with ssis

[Lidou_Cand]

Hello.

I hope you are well.

Especially in this period of health crisis.

I am working on a Microsoft BI solution.

I wish I could refresh a PowerBI Dataset with SSIS.

Do you know if it is possible to refresh a PowerBI dataset with SSIS?

Take care of yourself and your family.

Thank you for your help.

[v-easonf-msft · Accepted solution]

Hi , @Lidou_Cand 

We can  refresh Power BI dataset with REST API using SSIS.

For more details ,please refer to this document.
How to refresh power bi dataset rest api using ssis 

To accomplish the goal, firstly, we created the Azure Active Directory application and configured OAuth Connection Manager based on it. Then we retrieved Power BI dataset Id and used it in ZappySys SSIS PowerPack connector REST API Task. Finally, using the same REST API Task we made the HTTP request to Power BI REST API “refreshes” method and successfully refreshed the dataset. Therefore, if you need to make a call to another Power BI REST API method, you will be more confident in doing that, as you know how to call dataset refresh method already. Finally finally, if you make many and huge requests to Power BI REST API, make sure you check its limitations.

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

[Lidou_Cand]

Hello,

I've just seen your answer.

Thank you for your help.

Unfortunately, I can't test this solution because we do not have the ZappySys Rest API task.

Do you know if it's possible to resolve my issue without this Task ?

Thank you.

[amitchandak]

@Lidou_Cand ,

There is an option for SQL Server Analysis service database in sources if that can help

As far as I know, this is an upcoming feature discussed in Business Submit

https://mymbas.microsoft.com/sessions/67925f36-c04c-43c2-9411-bf51b8bd2cc6?source=sessions