Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How can Alteryx publish output to Power BI Server (on premise)

SDJ57
7 - Meteor

Currently, researching how to publish output to Power BI on premise utilizing the download tool. I am aware of the Power BI Output tool that is available from the Alteryx Gallery, but it is not an option I have available. So, I need to figure out how to send data through the download tool, I am assuming by the API, url and login details?

 

Is this going to require the JSON Parse tool?

 

4 REPLIES 4
dheissner
Alteryx
Alteryx

Do you know what the REST API calls to Power BI are and what the authentication mechanism will be required to call it and what data format it expects (JSON, XLSX, etc..)?  Once you know the details of the REST calls for Power BI APIs, along with any parameters, credentials etc.. they can be placed into the Download Tool and tested of course.

 

Here's an example I found from the Power BI documentation. For this you would place the JSON file content into the Payload of the Download Tool and select "POST" as the HTTP Action in the tool.

 

dheissner_0-1658785641608.png

 

 

And here's an example of what I'd put in the Download Tools "Payload" tab. 

 

dheissner_1-1658786214178.png

 

So we are using the "Download Tool" to upload data to Power BI. The Download Tool can be thought of as the make REST/Webservice Calls tool really. Hope that helps.

SDJ57
7 - Meteor

This is very helpful, thank you! I will be looking into this today and will follow up with other questions I have.

SDJ57
7 - Meteor

I do have another question though. Isn't REST API used only for web services?

dheissner
Alteryx
Alteryx

Yes, REST is a type of web service that uses the network, HTTP and URLs.

 

While APIs in general can be implemented in many different styles and protocols of which REST is one type.

 

REST APIs and web services are overlapping terms that get used interchangeably sometimes (like I did above)

Labels