Power BI - Multiple Tables in One Dataset

Question

Hi all

When using the Power BI Connector, is it possible to write multiple tables within a single dataset.

In the attached workflow I have two tables of data that I would like to have as separate tables within one PowerBI dataset called Dashboard. I was hoping that within the options menu of the configuration page the incoming connections could be set to differentiate the tables. So far I've not had any success. Is this possible, or should I just combine all the reports I need into one hideous massive table?

I've tried having the two outputs of the Select tool into one Power BI connector tool, but that wasn't working for me either.

Thanks!

@Sidey1978

Power BI Connector Test.yxmd

Sidey1978 · Answer

Hi @Felipe_Ribeir0

I'm using the latest version I think - V3.3.1.

Ah, just figured it out. I have to configure into the same tool at the first time of running. It looks like you can't add additional inputs to the connector once it has been run the first time. So I definitely need to get it right first time!

Cheers

Felipe_Ribeir0 · Answer

Hi @Sidey1978

Which version of the Publish To Power BI tool are you using? Here i am able to select the dataset and the table.

https://community.alteryx.com/t5/Community-Gallery/Power-BI-Output/ta-p/877894