Alteryx Designer Ideas

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

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

Submission Guidelines

Fix Power BI Output tool to reload an existing dataset without breaking reports

This idea is to fix one of the Power BI Output tool options for existing datasets.

 

Currently, if the 'Replace existing dataset' option is selected, the dataset is dropped and replaced with one having the same name.  Problem with this is that any reports or dashboards using that dataset become invalid (likely due to a changed internal identifier).

 

Idea is to change the 'Replace existing dataset' functionality to delete & replace the data within a dataset rather than deleting & replacing the dataset itself.

 

This behavior is described in the following thread & flagged as 'solved' although the workaround isn't practical as a true solution to the issue.  We'd like to see this supported more seamlessly via Alteryx.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Publish-to-Power-BI-breaks-linked-Powe...

8 Comments
kennethkwong
6 - Meteoroid

I strongly support this idea.

Dhuyvetter
5 - Atom

This would be incredibly helpful.

VojtechT
Alteryx
Alteryx
Status changed to: Accepted

Hi @hornungr ,

 

that's quite unfortunate solution for overwriting for sure. 

We will fix this in the next version of the connector.

 

Thank you,

 

Vojta, Product Manager

Data Connectors

DanHare
10 - Fireball

Please fix this !  Thanks.

VojtechT
Alteryx
Alteryx
Status changed to: Implemented

Hi everyone, I am very pleased to announce that the new version of the Power BI connector has been released and can be downloaded from our Gallery

 

The new version lets you select a workspace you want to work with, supports multiple multiple tables in a dataset, lets you overwrite, update, append or upsert data without breaking your dashboards and work in environments with proxy server as well. 

The most recent Alteryx Designer and Server, i.e. the 2021.2 version, is required. 

 

Vojta, PM for Data Connectors

Dhuyvetter
5 - Atom

Outstanding! I can't wait to test this out.

kennethkwong
6 - Meteoroid

Great Work!

hornungr
7 - Meteor

@VojtechT -  The release notes on the download page say the updated output tool is compatible with designer version 2021.3 and later.  Is that a typo?

 

Thanks!

 

AlteryxPowerBIOutputTool.JPG