Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

PowerBI

Hi - I am wanting to have Matillion fire an API Data refresh to the PowerBI service on successful completion of running our ETL orchestration (Final step being posting the data to snowflake).

I have found the PowerBI documentation (https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/), but would really appreciate someone pointing me in the right direction of how to implement this in Matillion; or even better, an example, or tutorial......

Thanks in advance!!

4 Community Answers

Matillion Agent  

Paul Johnson —

Hi Robbie,

I don’t have access to any power bi services. So I can only guide you on what I would attempt to do to implement this.

  1. First you would need to install powershell on the matillion instance, the linux distribution is not officially supported by Microsoft but I would follow the instructions for Centos7 here and see if that works
  2. Using the Bash Scripting compnents obtain an AAD access token, sample code here to help you
  3. Fire the API call to do the data refresh attaching your token (https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/refreshes)

If you are happy to share some credentials I can try and help you with it. Let me know how you get on.

Thanks,
Paul


Robbie Francis —

Hi Paul - Thanks for the info - It's a good start. How would you fire the API call from within the matillion flow though (Or is that the easy bit?)


Robbie Francis —

Can you e-mail me, and I'll share the login credentials?


Matillion Agent  

Laura Malins —

Hi Robbie

You can fire the API call from within Matillion by running a curl command in the Bash Script component

Thanks
Laura

Post Your Community Answer

To add an answer please login