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?
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.
And here's an example of what I'd put in the Download Tools "Payload" tab.
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.
This is very helpful, thank you! I will be looking into this today and will follow up with other questions I have.
I do have another question though. Isn't REST API used only for web services?
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)