hi @lcrosby have you checked out our Power BI tool on the Gallery? Try it out, see if it meets your needs, and if not, we'd love your feedback. Thanks for posting!
Unfortunately not, unless the most recent update has changed its functionality, the tool can only output to Power BI. I want to use the PBI API to pull data from Power BI to get the usage statistics/audit logs for a given report.
It would also be useful to be able to grab a dataset from Power BI, amend/append it and then push it back onto Power BI too.
Apologies, I did not know that "working with an existing dataset" is like saying that the Output Data tool can "work with an existing excel file." As soon as this idea meets the necessary criteria, product management will review it.
We are also very interested in a PowerBI Input tool as well for this same use case. This functionality would be extremely valuable as PowerBI Usage Metrics only offer a snapshot of usage for the past 90 days. There is no way to gather cumulative Power BI Usage data automatically.
Visualizations already contain data that are calculated. Most of the time the requests I get are I need the results from this Power BI integrated into another report. If the other process is already built in Alteryx the ability to pull the existing data from Power BI and pulling it into the existing workflow would be an immense time saver. Only option at this point is to manually export data from Power BI which is time consuming especially if the dataset contains more rows of data than Power BI allows you to export at a time.