on 04-14-2016 03:21 PM - edited on 07-27-2021 11:41 PM by APIUserOpsDM
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: https://help.alteryx.com/current/MicrosoftPowerBIOutput.htm 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'llneed 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'smove over to the Designer!
Step 1: Let'smove to Alteryx
Step 2: Configuration – Dataset Name
Step 3: Configuration – Table Name
Step 4: Operation
Step 5: Advanced Tab
Step 6: Run the workflow!
Tips and Tricks
Common Errors
Publish to Power BI (2) Tool #2: The external program "PBIGetAccessToken.exe" returned an error code: -532462766.
Error: Publish to Power BI (48): Tool #4: The type initializer for 'Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext' threw an exception.
[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=2.12.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' exists]
Power BI API error….HTTP/1.1 400 (‘error”(code…….
The browser based authentication dialog failed to complete. Reason: The download has failed (the connection was interrupted)
Authentication failed: Refresh Token is malformed or invalid
An Array can’t be at the top level
If you continue to have problems with the Power BI Macropleasecontact Alteryx Support.
Best,
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_dup_424 & @Martin_Miller
This is not available in the 2018.2 release of Alteryx Designer.
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Save-Workspace/idi-p/141865
Best,
Jordan
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.
Cheers
Charlie
Hi @charlep_dup_424,
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.
Best,
Alex
Hi ,
I received the following error:
Error: PublishToPowerBI (1): Tool #4: <HTML><HEAD>
Tool 4 in the macro suggests that the client ID, Secret is not valid. Are you using this option?
Best,
Jordan
Hi Jordan,
I am using the interactive authorization option.
Regards
Mornay
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?
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)
Cheers
Charlie
Hi,
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.
Thanks
Hiro
Hi
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?
Thanks
Hi,
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.
Hi
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
JeMe
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?
@Prashant_Iyer the Publish to Power BI Tool has just recently been deprecated and replaced with the Power BI Output Tool. https://help.alteryx.com/current/MicrosoftPowerBIOutput.htm
@MartinJuguera - I'm having the same problem with the new tool.
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\connections.py", line 84, in ii_init
token_updater=self._update_token
File "C:\Users\[USERNAME]\AppData\Roaming\Alteryx\Engine\../Tools\power_bi_output_v2.1.1\Lib\site-packages\requests_oauthlib\oauth2_session.py", 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\oauth2_session.py", line 119, in token
self._client.populate_token_attributes(value)
AttributeError: 'AzureActiveDirectoryWebApplicationClient' object has no attribute 'populate_token_attributes'
I am also getting the exactly same 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\connections.py", line 84, in ii_init
token_updater=self._update_token
File "C:\Users\[USERNAME]\AppData\Roaming\Alteryx\Engine\../Tools\power_bi_output_v2.1.1\Lib\site-packages\requests_oauthlib\oauth2_session.py", 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\oauth2_session.py", line 119, in token
self._client.populate_token_attributes(value)
AttributeError: 'AzureActiveDirectoryWebApplicationClient' object has no attribute 'populate_token_attributes'
Can Alteryx support team can help here.
Regards
Rajaniesh
Can you access powerbi online? This usually suggests firewall issues as Alteryx cannot talk to the website
Best,
Jordan
Hi Jordan,
This connector is designed to connect to a Power BI server hosted by Azure but has not ability to connect to your local Power BI server.
When compare to Tableau connector it seems this connector has not evolved as much in recent years but Power BI is growing fast in the market.
Do you know if there are any plans to include the feature to connect and publish to a local Power BI server?
Thanks,
Hello @jmurillo22
Thanks for your feedback on this knowledge piece. I would recommend that you create an official Idea under the Designer- Idea section making this exact request. If you know anyone else who feels the same way please make sure you have them visit your post and star it!
Thanks!
TrevorS