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!
Free Trial

Forum

Trouvez des réponses, posez des questions, et partagez votre expertise d’Alteryx.
TIPS de la semaine

Chaque semaine, découvrez de nouvelles astuces et bonnes pratiques pour devenir un expert !

Voir l'index

Power BI Output - Unable to update a dataset created via Power BI Desktop

NinjaDoree
Météore

Hello to all of you,

 

I have a problem with the new "Power BI Output" v3.0.0 module that does not allow me to update via Alteryx a dataset in my workspace that was initially created via Power BI Desktop.

 

Do you have a solution?

 

NinjaDoree_0-1631698886639.jpeg

 

Thank you vey much in advance and have a nice day

 

3 RÉPONSES 3
carlosteixeira
15 - Aurora
15 - Aurora

Hi @NinjaDoree, How are you doing?

 

Are you tried this actions below?

 

1 - check that the Power BI tool version is compatible with the Designer version from this tool download page:

https://gallery.alteryx.com/#!app/Power-BI-Output/561687f8aa690a14c493c9bd

 

2 - check that you are following the steps and setting up the tool correctly. More details on this page:

https://help.alteryx.com/en-us/20213/designer/microsoft-power-bi-output-tool

 

3 - try to upgrading the Power BI workspace as per the steps on this page:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-upgrade-workspaces

 

Best Regards

Carlos A Teixeira
NinjaDoree
Météore

Hello to all of you,

 

After exchanging with the support, the only way to do that is to create a streaming data set in Power BI Cloud. After creating this data set you can update it with Alteryx. If you create a data set with Power BI Desktop you won't be able to update it via Alteryx (for the moment).

 

Warning : By creating a streaming data set you won't be able to access to Power Query (Power Query is now Alteryx).

 

Best regards 

VojtechT
Alteryx
Alteryx

Hi @NinjaDoree ,

 

my experience is little bit different. 

The reason why you cannot edit some datasets is because they are not of "push" type, i.e. they were not created using APIs. For some reason Power BI let's use work with datasets over API only if those dataset were also created via API. Which is not the case of datasets uploaded from Power BI. 

 

My recommended solution would be:

  1. Design the dataset and dashboard in Power BI Desktop
  2. Knowing the structure of the final dataset, create a new dataset with the same structure through Alteryx Designer and Power BI Output connector
  3. Modify the dashboard to read the dataset from PBI Cloud created in previous step
  4. Publish dashboard into Power BI

 

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
Étiquettes