Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Server Ideas

Share your Server product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Alteryx Gallery/Power BI.com Integration

 

Alteryx has the power (no pun intended), and Power BI has the visualizations.

 

But, why use two interfaces when you could use one?

 

A concept we started kicking around was embedding a PowerBI.com visualization into the Alteryx Gallery.

 

In theory this should work, but we're interested to hear if anyone else has tried it or has a best practice for embedding links into Gallery reports.

 

It should be possible to take the dashboard link:

Dashboard Link.png

 

Then, drop that into a text input tool to have it embedded in the output.

The idea is that certain dashboards would be linked to certain report results to allow an end user to drill into the output of the Gallery report specific to each result output, thus creating an interactive drill down in one interface.

 

Thoughts?  Ideas?

 

 

 

 

6 Comments
NeilR
Alteryx Alumni (Retired)

I have gotten this to work with Power BI's publish to web functionality. First you get the embed code from Power BI:

<iframe width="800" height="600" src="https://app.powerbi.com/view?r=eyJrIjoiMjcxYTliYjYtZjE4YS00ZjJkLTg5NjctNjI0YWRiN2NjZDA0IiwidCI6IjUyMmYzOWQ5LTMwM2QtNDg4Zi05ZGViLWE2ZDc3ZjFlYWZkOCIsImMiOjN9" frameborder="0" allowFullScreen="true"></iframe>

Then we add some wrapper code to get it ready for Alteryx reporting tools:

<htmlpassthrough><![CDATA[<iframe width="800" height="600" src="https://app.powerbi.com/view?r=eyJrIjoiMjcxYTliYjYtZjE4YS00ZjJkLTg5NjctNjI0YWRiN2NjZDA0IiwidCI6IjUyMmYzOWQ5LTMwM2QtNDg4Zi05ZGViLWE2ZDc3ZjFlYWZkOCIsImMiOjN9" frameborder="0" allowFullScreen="true"></iframe>]]></htmlpassthrough>

The above works fine when viewing PCXML locally, but when saved to the Gallery, some Gallery css messes up the formatting. To fix it we add a little css of our own:

<htmlpassthrough><![CDATA[<style>#powerbi-iframe{height: 800px !important;}</style><iframe id="powerbi-iframe" width="800" height="600" src="https://app.powerbi.com/view?r=eyJrIjoiMjcxYTliYjYtZjE4YS00ZjJkLTg5NjctNjI0YWRiN2NjZDA0IiwidCI6IjUyMmYzOWQ5LTMwM2QtNDg4Zi05ZGViLWE2ZDc3ZjFlYWZkOCIsImMiOjN9" frameborder="0" allowFullScreen="true"></iframe>]]></htmlpassthrough>

I've published this example on the Gallery here. I suspect you can adapt this to work with your dashboard.

patrick_mcauliffe
14 - Magnetar
14 - Magnetar

You are my hero.

Thank you!

Atabarezz
13 - Pulsar

Awesome!

Community_Admin
Alteryx
Alteryx
Status changed to: Inactive
 
Community_Admin
Alteryx
Alteryx

The status of this idea has been changed to 'Inactive'. This status indicates that:

 

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

AliceM08
5 - Atom

This is a great idea. Is there a way to pass parameters to filter the report?