Hello,
So we are using Power BI for most of our ETL activity and reporting. However, one area is using Alteryx to compare the data with the goal of using Power BI as the visualization layer.
I have the Power BI Output Tool working successfully. One limitation mentioned on that page is as follows:
"Only one table may be published per dataset, per Connector tool. Outputting multiple tables per dataset is not currently supported by the Connector tool. If you want to publish more than one Power BI table in your Alteryx Workflow, you must add multiple Power BI Output Connectors to your workflow and publish each table under its own dataset."
Given that, my idea was to publish to multiple datasets, then combine the multiple datasets using Power BI Desktop.
But I'm hitting a snag as using the Power BI Service as a Data Source disables your ability to add any other Data Sources.
From a page on the basics, under the Reports section:
"ONE report...
is contained in a single workspace.
can be associated with multiple dashboards within that workspace (tiles pinned from that one report can appear on multiple dashboards).
can be created using data from one dataset. (the slight exception to this is that Power BI Desktop can combine more than one dataset into a single report and that report can be imported into Power BI)."
Does anyone know if this is possible? I can try to get the Alteryx output into a single table, but it would be much preferred if I could output multiple tables to a single dataset (which doesn't seem possible with the current connector) or output tables to multiple datasets then combine them in Power BI Desktop.
Thanks,
Matt
