The Microsoft Power BI Output Tool uses the Power BI REST API to upload a data table from your Alteryx workflow to the Power BI web application.
Added support for certificates which contain special characters.
Compatible with Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.
Compatible with AMP engine only.
FIPS capable.
SSL/TLS validation is now performed against Windows Certificate Store.
Added option to use Service Principal.
Added option to disable SSL validation (not recommended, debugging purposes only).
Built-in multitenant Azure App with an option to use custom Azure App.
Supports multiple table inputs.
Keeps existing dataset and its structure with updating/overwriting data.
User can select which workspace to work with.
Proxy support.
Add/correct the metadata search tags to both the config.xml in the yxi package and the tool’s configuration .xml files.
The new YXI Power BI Output Connector with the following improvements from existing macro:
Adds support for selecting Power BI workspaces other than “My Workspace”.
Updates UX to match other YXI Connectors.
This tool uses a .yxi file format. A .yxi file is a package that includes an Alteryx Tool and all of its dependencies zipped into a single file. When this file is imported into Alteryx, the tool is added to the tool palette in the category specified by the tool.
When sharing a workflow that uses a .yxi tool, the tool is not included and must be installed by the recipient.
After you download this xyi file. What is next?
double click it or open as a workflow straight from Designer. then follow the installation process. at the end the tool is present on Connectors pallet or you can simply search for it in Search (top right on your screen) and drag and drop it on canvas.
Is there a version that is compatible to 2021.2 version of Alteryx?
Hi, thanks a lot for this tool.
I use the last available version (v3.1.0). This works fine with Alteryx Designer but when I run the workflow within my Server, i got a error message :
"Bad request syntax or unsupported method."
I think this is an authentification issue because i get the same message with Designer if I don't configure the authentification after opening the workflow.
Do you have any clue to help me?
Kind regards,
FYI, I discovered an issue with the Azure App registration API permissions with this tool in version 3.1, and I have found that the issue still persists with 3.2. This post details the issue and how to fix it yourself if necessary:
Power BI Output Tool - Azure App Registration API ... - Alteryx Community
Basically there's a legacy permission "Group.Read.All" included in a couple of files in this plugin that no longer exists in Azure, so if you (your Azure admins) set up an App Registration manually according to the instructions Alteryx provides on their "Microsoft Power BI" page and grant consent to all of the required permissions, you still get prompted for additional consent in Alteryx because of that legacy permission and can't continue. The fix I've detailed in the included post is to remove the references to that legacy permission.
Hopefully the Alteryx folks will included this fix in a future update.
Got this error:
How can I fix it ?
@Juan_Zamora , could you confirm that you are using a supported version of Designer?
Hi, will this tool work on Alteryx Design 2020.2.3 version?
I have the same problem that Juan Zamora. Please help!
Is PowerBI_v3.2.0 compatible with Alteryx version 2018.4.5.55178 ?
Getting below while installing. If this is not compatible, which version of Power BI output tool is compatible with 2018 Alteryx version?
Hi, I'm receiving the same error as @Juan_Zamora.
I am running Alteryx Admin Designer 2020.3.8.30287. Is my version compatible with this Power BI tool or am I experiencing a separate issue.
Dear all where i can find the link to download PowerBI_v3.0.0? when i click in download only have the option for PowerBI_v3.3.
Is this new version compatible with Alteryx Server 2022.3.1.430?
Authentication Method seems not to work
I am trying to sign in via internet browser
When I run the flow saving in the power bi in the alteryx designer, it works, but when I try to run it manually in the gallery, it gives this error:
'str' object has no attribute 'get' (ToolId: 1)
Does anyone know what i can do,
Thanks
I am receiving a "Failed to Connect to Platform" error. Has anyone gotten this problem?
Is there a silent install function so this can be pushed from centralized management software (e.g. SCCM)?
i have problems with the tool authentication method
I am having trouble outputting to the tool. When I include dates in the dataset it throws an error. I followed the directions to convert to a string before outputting and this runs without error, however, once in PowerBI I am unable to convert back to a date. I am not able to use this connector unless it allows me to include dates in the dataset. Is there a workaround that I am not seeing in the help page?
I'm trying to connect alteryx using the output with power bi to an existing report, but I can't configure access to the API.
Does anyone know the solution?