I'm successfully pushing data from Alteryx to PowerBI. Here's my issue:
The Power BI Output tool has 3 options:
I would like to schedule Alteryx to push updated data to my dataset and when I look at it's report, I have updated data.
Is there a better option, maybe even with Power BI?
Thanks,
deX
Solved! Go to Solution.
Hi @deXtron ,
unfortunately, there is currently no option to update the target data set in PowerBi (only replace, append or create a new one).
It is already addressed internally.
I have two workarounds for you:
a) Write the data from Alteryx not directly to PowerBI, but into a database. Then refresh your PowerBI dashboard via the database. In case this is not an option for you:
b) create an additional "flag" column [e.g. timestamp with the formula DateTimeNow() ] in PowerBI - filter on the latest timestamp, only
I hope this helps you.
Best regards
Phil
We'd like to see Alteryx enhanced to support this more seamlessly. I've added it as an idea here:
Fix Power BI Output tool to reload an existing dataset without invalidating reports and dashboards
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