Accessing Power BI Rest API's from Alteryx

[Jaimon_office]

Hi Experts,

I'm reaching out to gather insights on accessing Power BI REST APIs through Alteryx, for tasks like cloning templates, pushing data to cloned templates, adding users, and sharing published data etc.

If you have any experience with this integration, I would greatly appreciate any guidance on the steps involved. Additionally, if there are sample workflows or reading materials available, they would be incredibly helpful.

Thank you in advance for your assistance.

[abacon · Accepted solution]

@Jaimon_office I have a lot of experience with it. Have you done any work with Power BI APIs in general? That is the tricky part to setup.

https://learn.microsoft.com/en-us/rest/api/power-bi/

https://www.youtube.com/watch?v=APj3MFt2w5I

If you do have the PBI APIs setup, let me know and I can move to the next steps.

Bacon

[Jaimon_office]

Thanks @abacon 

Sorry, I haven't worked with Power BI API's but have worked with other API's. Its my first time with Azure environment. Thanks for the video shared it gave me some idea. Basically we are exploring the feasibility of a self service portal from Alteryx gallery to push the data respective template sitting in PBI online environment. Based on user selection template  needs to change and client specific dashboard we updated would then need to reach specific end users as a link with usage access restricted. Would this be possible from Alteryx Interface?

Just raised ticket to enable API setup tagging a service account. Out of curiosity, would we need the service account credentials to be passed every time when we are making the API call?

Anything specific to consider while setting up the API setup?

Thanks again for your help its much appreciated

[abacon]

@Jaimon_office Yes, the credentials would need to be passed every time to generate the bearer token to make the API calls. However, I have a Power BI authentication macro (see attached) that allows you to add the information right into the workflow and ensuring automation. All you need is the Client ID, the Client Secret, and the Tenant ID to run the macro.

For the specific use case, without seeing what you are trying to do, it would be hard to say if possible or not. My usual answer is - if it can be done in general, it probably can be done in Alteryx. How to do it is another question. Once the APIs are setup, would a call to discuss be more helpful?

Bacon

[Jaimon_office]

Thank you so much. Will keep you posted

[abacon]

@Jaimon_office For sure! I have used Power BI and Tableau APIs quite a bit so reach out if you have anymore questions. I would assume your use case is possible, but it again goes to how to do it.

Bacon