Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
New Data Science Blog

Check out the latest post: All Models Are Wrong


The 'How to Guide' to Power BI


The Publish to Power BI Tool has been deprecated and replaced with the Power BI Output Tool. See here for more information about the Power BI Output Tool: The rest of this article refers to the deprecated Publish to Power BI Tool.

By combining Alteryx and Microsoft Power BI, organizations can streamline and accelerate the process of preparing and analyzing data. This provides a faster way to deliver an end-to-end experience for data access, preparation, analysis, visualization and consumption — delivering deeper business insight faster with a more complete set of data.


With the new macro connecting to Power BI within Alteryx is even easier!


Depending upon your intentions with the Power BI tool you may need to sign up for Power BI and Microsoft Azure or just Power BI.  If you are only using Power BI independently then Option 1 will be fine, however if you have corporate deployment of Microsoft Azure then Option 2 would be best.


Option 1:

This option is ideal if you would like to manipulate your data in Alteryx and then use the visualization methods inside Power BI. This set up is perfect if you are not looking to manage users or connect to local or network directories.


Option 2:

This option if for a cooperate deployment who utilize the Microsoft Azure. To use the Alteryx application it needs to be registered by your Azure administrator and a Client ID obtained from them. When using an account you setup yourself, you'll need to perform the following Azure Active Directory administration tasks to obtain the Client ID. It is recommended to get help from someone familiar with Azure Active Directory management, however the links below give good step by steps guides on how to set this up.


Once you have selected your option let's move over to the Designer!


Step 1: Let's move to Alteryx


 Pic 3.png


  • You can now drag the macro onto the canvas and use it to upload your modified data to Power BI.

Step 2: Configuration – Dataset Name


  • Enter the dataset name as you want it to appear in Power BI


Step 3: Configuration – Table Name


  • Enter that table name as you want it appear in Power BI


Step 4: Operation


  • Create New: This will create a new dataset/table. If the dataset already appears it will append ‘_2” to the dataset name.
  • Append: This will append records to the existing table. (Dataset name has to be exact)
  • Replace: This will overwrite the existing table. (Dataset name has to be exact)


Step 5: Advanced Tab


  • Interactive authorization: This option will prompt the user for their username and password for Power BI. If you are looking to schedule this workflow or upload to the Gallery please choose ‘Hard-coded credentials’ because the interactive authentication will not be able to retrieve the client ID.
  • Refresh token: This option caches a ‘refresh token’ which allows the user to re-run the workflow without the needs to re-authenticate until the refresh token expires. (Check with Microsoft for expiration policies). Uncheck this box if attempting to publish to a different Power BI account so that the user will be prompted for a different username. Unchecking this box and running the workflow will delete the cached refresh token which could be useful if the token becomes corrupted.
  • Hard-coded credentials: Please enter your Power BI Username; Password; and client ID. To obtain. This is the ideal choice if you are looking to schedule or run this workflow on the gallery.


Step 6: Run the workflow!


  • You can now run the workflow and Publish to Power BI.


Tips and Tricks


  • Our best practice is to select ‘Work or school account’
  • Power BI has about a 2GB limit in the cloud, so clean it up now and then.


Common Errors


Publish to Power BI (2) Tool #2: The external program "PBIGetAccessToken.exe" returned an error code: -532462766.


Pic 7 PBInotgetting.png


  • This error is related to write permissions when writing out the access token. This error should be fixed in the latest release on the Macro District
  • As the Tips and Tricks mentioned please select ‘Work or school account’ and enter your credentials. This will prompt a new permissions window. Please hit ‘Accept’ and you should be able to write out the access token correctly.

pic 10.png


  • If you continue to get this error please run Alteryx as Administrator.



Error: Publish to Power BI (48): Tool #4: The type initializer for 'Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext' threw an exception.


  • Please check your .NET Framework (the easiest way to find out is probably to navigate to your installed programs via control panel), this tool requires a .NET 4.5 framework.



[Publish to Power BI (1) Tool #4: Loading an assembly required for interactive user authentication failed. Make sure assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35' exists]


  • This issue occurs when one of the dependent files (Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms.dll) is missing or corrupt. Re-installing the tool should resolve this issue.



Power BI API error….HTTP/1.1 400 (‘error”(code…….


Pic 6 - Power BI API.png


  • Open PBIX from Power BI webapp, then try to use macro to append/replace dataset of same name as PBIX results in error. The solution is to use a different dataset name.
  • This is a bug in our JSON Build tool please do not have fields containing a period



The browser based authentication dialog failed to complete. Reason: The download has failed (the connection was interrupted)


Pic 8 browser based.png


  • Please enable TLS in IE advanced settings within internet options.

Pic 5.png




Authentication failed: Refresh Token is malformed or invalid


Pic 9.png


  • The refresh token is corrupted, please delete the refresh token in the same folder of the macro or uncheck refresh token in macro interface.

Pic 4.png




An Array can’t be at the top level




  • This is a bug with our JSON build tool please do not start with a number


If you continue to have problems with the Power BI Macro please contact Alteryx Support.




Jordan Barker

Professional Services  


Hi, I am experiencing the error with the power bi JSON bug , 'An array can't be at the top level.' My field/column names do not begin with a number, however the rows contain numbers. How do I fix this? Thank you! 


Is there any way to publish data direct to a PowerBI App workspace (rather than My Workspace) - for example if I am working collaboratively with a team?


I would agree with @charlep ... is there a way within the Macro to define which Workspace to publish the PowerBI Data set?


Hi @charlep & @Martin_Miller


This is not available in the 2018.2 release of Alteryx Designer.






Hi Jordan


I think the link you provided is for saving your Alteryx workspace including all the workflows. We are asking if it's possible to push to a specific PowerBI Online (Microsoft SaaS) data store, which is something different.




Hi @charlep,


No. With the existing Publish to Power BI Tool, it is not possible to specify a workspace other than the default ‘My Workspace.’ However, we are looking at providing the option to select another workspace in the next version of the PowerBI tool.





Hi ,


I received the following error:

Error: PublishToPowerBI (1): Tool #4: <HTML><HEAD>


Hi @Monkie


Tool 4 in the macro suggests that the client ID, Secret is not valid. Are you using this option?





Hi Jordan,

I am using the following option:



PwC – a triple A + level 1 contributor, committed to ongoing

The information transmitted is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the material
from any computer.

Sorry @Monkie I cannot see the image.






Hi Jordan,

I am using the interactive authorization option.



I just wanted to add my vote for allowing to save to different workspaces with the PowerBI Connector.  Is there a place I can go to add the idea or vote for it?

Community Operations Manager
Community Operations Manager



You can go to the Designer Ideas board and post your idea. Alteryx-Designer-Ideas




Hi team,


Is there any possibility to extract information from a Power BI database and bring it to my Alteryx?


Thanks in advance!


@forebrunialti - what do you mean by extract information from a Power BI database?


When you publish to PowerBI, it sits as a dataset in the Power BI Service (effectively I believe it's SQL Server Analysis Services repurposed).


You can access it from Excel as a data source, but I believe at the moment the feature set isn't quite the same as SSAS so you can't consume the PowerBI data in e.g. Alteryx.

The best bet if you need both, is to push the data into a SQL Database, and then from there into your PowerBI model. That way you have the DB data as well as the cube - you won't be able to get any of the additional measures you've created in the PBI Cube though, so these will need to be pushed into the DB.

The other alternative is to push the data into SSAS / Azure Analysis Services Tabular Cube, and from there into PBI (and Alteryx)







I really agree that specifying the Power BI Service workspace to publish to is a critical feature that needs to be developed in the next version of Power BI tool.

I also think that publishing multiple tables in 1 Power BI dataset is needed. Because Power BI can contain multiple tables in 1 dataset and use relationships to connect the tables, the current Power BI tool that can only have 1 table in 1 dataset is a big restriction.






I was able to create a new dataset/table with the Interactive authorization

However it didn't let me Replace.


I got an error like the table doesn't exist


Can you help?





I don't seem to be having any luck getting the Power Bi connector button on my connectors page.  I have downloaded the macro and can see that the macro has saved in the place I have specified however that's all I can see.  I don't get the grey icon in my connectors tab.

Do you know why this may be the case?

Thank you if you can help.




Try restarting your computer


Hi Jordan,

I am getting the error, "The browser based authentication dialog failed to complete. Reason: The server or proxy was not found", when trying to publish to Power Bi. Do you by chance know why?  I have spoken to our IT Helpdesk and they do not have a solution.   Hoping you can help.

Kind regards


I tried searching for "Publish to Power BI Tool" in Alteryx Gallery, But I was not able to find it. Instead I found "Power BI" output. Are both of these the same?


Sr. Community Content Manager
Sr. Community Content Manager

@Prashant_Iyer the Publish to Power BI Tool has just recently been deprecated and replaced with the Power BI Output Tool.

I need help i jus reinstall the tool and it doesn't work anymore, i don't have the option to choose "Hardcoded Credential" or "Interactive autorization" and i have also the following error : Traceback File "", line 3, in ModuleNotFound Error : No module named 'power_by_output' How can i solve this problem? Thanks

@MartinJuguera - I'm having the same problem with the new tool.

Alteryx Certified Partner

I'm getting the following error:


Error: Power BI Output (3): Traceback (most recent call last):
File "C:\Users\[USERNAME]\AppData\Roaming\Alteryx\Engine\../Tools\power_bi_output_v2.1.1\power_bi_output\", line 84, in ii_init
File "C:\Users\[USERNAME]\AppData\Roaming\Alteryx\Engine\../Tools\power_bi_output_v2.1.1\Lib\site-packages\requests_oauthlib\", line 69, in __init__
self.token = token or {}
File "C:\Users\[USERNAME]\AppData\Roaming\Alteryx\Engine\../Tools\power_bi_output_v2.1.1\Lib\site-packages\requests_oauthlib\", line 119, in token
AttributeError: 'AzureActiveDirectoryWebApplicationClient' object has no attribute 'populate_token_attributes'

Hi @MartinJuguera & @mchamps


Please reach out to to log this issue