Accessing Power BI Rest API's from Alteryx

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.

Workflow

Developer

Gallery

Developer Tools

Transformation

API

Apps

Download

Sharepoint

Power BI

App Builder

GenAI Tools

Accepted answers

abacon

@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

All comments

abacon

@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

PowerBI Authentication.yxmc

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703