Forum Discussion

Lidou_Cand's avatar
Lidou_Cand
Icon for Helper III rankHelper III
6 years ago
Solved

Refresh PBI dataset with ssis

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...
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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.

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    Lidou_Cand
    Icon for Helper III rankHelper III
    6 years ago

    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.