Alteryx Gallery/Power BI.com Integration

[patrick_mcauliffe]

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:

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?

[NeilR]

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]

You are my hero.

Thank you!

[Atabarezz]

Awesome!

[Community_Admin]

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]

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