We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Power BI - Multiple Tables in One Dataset

Sidey1978
8 - Asteroid

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.

 

Sidey1978_0-1674814854543.png

 

Thanks! 

@Sidey1978 

 

 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

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.

 

Felipe_Ribeir0_0-1674817383046.png

 

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

 

 

Sidey1978
8 - Asteroid

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 

 

 

Labels
Top Solution Authors